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-09-28T07:53:02.190' ,`MLSNumber` = '60781553' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398389' ,`Longitude` = '-95.498084' ,`PhotoCount` = '25' ,`PostalCode` = '77318' ,`RoomCount` = '11' ,`ListPrice` = '813663.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset Tree Court' ,`StreetNumber` = '410' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 60781553 - Built by Highland Homes - December completion! ~ Popular all brick open plan on wooded lot with 13\' ceiling height. Kitchen has two-tone kitchen cabinets - white upper perimeter and natural maple w/Black Wash on lower perimeter. White quartz countertops and complementary backsplash. Stainless appliances with double oven and 36 inch cook top, and single basin sink. Enhanced laundry room to create extra room and a second walk-in pantry. All beds have walk-in closets. Wood floors throughout main living areas. Tankless water heater system and smart home technology also included. Full sod yard and full yard sprinkler system. Easy access to schools, shopping, dining and medical facilities.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 / Block 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '12482' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386024' WHERE `Matrix_Unique_ID` = '206696621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:35:15.617' ,`MLSNumber` = '36324363' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.290542' ,`Longitude` = '-95.564350' ,`PhotoCount` = '20' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Sky Top' ,`StreetNumber` = '344' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2189' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry with 12-foot tray ceiling. Open kitchen features center island, 5-burner gas cooktop and corner walk-in pantry. Dining area flows into open family room with wall of windows and a wood mantel fireplace. Large primary suite includes bedroom with wall of windows. Double doors lead to primary bath with dual vanities, garden tub, separate glass-enclosed shower and two walk-in closets. Secondary bedrooms feature walk-in closets. Extended covered backyard patio. Mud room off two-car garage.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965281 - Woodforest 81, BLOCK 1, Lot 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`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,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386025' WHERE `Matrix_Unique_ID` = '207223143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:59:16.633' ,`MLSNumber` = '56066914' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472712' ,`Longitude` = '-95.529657' ,`PhotoCount` = '44' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '799991.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Leaf' ,`StreetNumber` = '1919' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3827' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 56066914 - Built by Highland Homes - October completion! ~ No back neighbors! Open concept is perfect for entertaining. Custom kitchen cabinet upgrade overlooks the spacious family room and corner painted brick fireplace to the ceiling. Sliding glass doors lead out to the oversized covered patio. Walk through master closet to laundry room. Game & Media room upstairs. Huge secondary bedrooms! Smart home package included w/ tankless hot water heater.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Highland Homes' ,`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` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '5/1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8443' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386025' WHERE `Matrix_Unique_ID` = '207940502' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T08:00:00.000' ,`MLSNumber` = '4995343' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437750' ,`Longitude` = '-95.434452' ,`PhotoCount` = '40' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '456515.00' ,`Status` = 'Active' ,`StreetName` = 'Tioga View' ,`StreetNumber` = '1719' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home featuring a spacious kitchen with stainless appliances, granite counter tops, upgraded 42\" cabinets, vinyl flooring, a walk in pantry and is open to the huge family room and spacious dining area. The master suite is separate from the other bedrooms and has TWO walk in closets, larger closet has easy access to laundry room, stand up shower and relaxing oval tub in master bath. Covered back patio to complete the house - it just needs you and your family to make it a home.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 BLK 3 Sec 7' ,`LotDesciption` = 'Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386025' WHERE `Matrix_Unique_ID` = '208371750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:49:41.450' ,`MLSNumber` = '88408902' ,`ListAgentFullName` = 'Lisa Sanders' ,`ListOfficeName` = 'Living Vogue Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.034585' ,`Longitude` = '-94.872085' ,`PhotoCount` = '47' ,`PostalCode` = '77535' ,`RoomCount` = '3' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Ford' ,`StreetNumber` = '405' ,`StreetSuffix` = 'Avenue' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this fabulous find in Fordland Estates on a 1/3 acre lot! The storage building is a bonus and still has lots of room for backyard activities. This beauty boasts a split floor plan for easy living. Once inside, you will love everything this home offers. The kitchen offers abundant cabinetry, counter space and breakfast bar. Open kitchen and family room - great for entertaining! The primary suite is large in size-matched to a large master bath with a garden tub and separate shower. Secondary bedrooms are tucked away from the primary suite. Easy drive for the commuter with convenient access to SH 146 and Hwy. 90. No HOA dues! Schools are in close proximity. Don\'t miss out on this charmer!' ,`Acres` = '0.32' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'FORDLAND ESTATES, SEC 1, LOT 2, ACRES .32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13939' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Fordland Estates, Sec 1' ,`TaxAmount` = '5427' ,`TaxRate` = '2.4832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386025' WHERE `Matrix_Unique_ID` = '208720202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:15:58.717' ,`MLSNumber` = '74261047' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749283' ,`Longitude` = '-95.880158' ,`PhotoCount` = '40' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '655000.00' ,`Status` = 'Active' ,`StreetName` = 'Beech Tree' ,`StreetNumber` = '29507' ,`StreetSuffix` = 'Bend' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenmeade home has a brick and stone elevation with a beautiful front porch in Jordan Ranch. This Four Bedroom, 3 ½ Bath home has a two story Family Room, open design to the Kitchen and single Dining Room. The beautiful Kitchen features a large island, 2 pantries, stainless steel appliances, under-cabinet lighting and towering cabinets! The Owner\'s Retreat has vaulted ceilings, a soaker tub and a large shower. The home has a second Bedroom on the first floor with in-suite Bath, great for guests. Upstairs has two Bedrooms, and a Full Bath. Also upstairs, you can enjoy family night in the Retreat or the massive Media Room as well!  The home also features an amazing covered outdoor living space! All this on a quiet 70 foot North facing home-site with plenty of yard space! Check out our energy savings!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 09 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386025' WHERE `Matrix_Unique_ID` = '209323361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:37:01.227' ,`MLSNumber` = '71315739' ,`ListAgentFullName` = 'Dennis Dunlap' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.326560' ,`Longitude` = '-94.939898' ,`PhotoCount` = '29' ,`PostalCode` = '77563' ,`RoomCount` = '10' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Pompano' ,`StreetNumber` = '494' ,`StreetSuffix` = 'Street' ,`City` = 'Hitchcock' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '!!!!!!PRICE REDUCED!!!!!Thank you so much for viewing. Stunning canal waterfront home located in the highly sought-after Bayou Vista Subdivision just minutes from Galveston. This property features your own family party deck covered and uncovered. The home offers spacious 3 bedrooms and 2 bath upstairs. Hardwood floors in all\r\nliving area upstairs. Huge family room for great entertaining and open concept between all rooms. Your \r\nwaterfront living awaits you! boat lift, lit pier and party deck. Downstairs offers a complete efficiency apartment \r\ngreat for guests. ALL MEASUREMENTS ARE APPROXIMATE. PLEASE VERIFY SCHOOL ZONE WITH DISTRICT.\r\nPLEASE VIEW PUBLIC NARRATIVE ATTACHMENT FOR MORE DETAILS' ,`Acres` = '0.1267' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 494 NEW BAYOU VISTA ADDN 4A' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '5520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'New Bayou Vista 4a' ,`TaxAmount` = '8417' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386025' WHERE `Matrix_Unique_ID` = '209635771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:46:26.313' ,`MLSNumber` = '5790061' ,`ListAgentFullName` = 'Richard Luebeck' ,`ListOfficeName` = 'Red Lion Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704480' ,`Longitude` = '-95.788112' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '15' ,`ListPrice` = '605000.00' ,`Status` = 'Active' ,`StreetName` = 'Seventh Heaven' ,`StreetNumber` = '23807' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home at 23807 Seventh Heaven, located in the highly sought after Seven Meadows Subdivision, in Katy Texas. This home has 4 bedrooms, 2 1/2 bathrooms, 2 car detached garage! Pool with Water Slide! And Waterfall! Sprinkler System & Mosquito Misting System! Soaring Ceilings, Open Floor Plan, Huge Owner Retreat with Huge His & Hers Walk In Closets, Study/Office, Flex Room, Formal Dining, Media Room. The Chef\'s Kitchen has Lots of Cabinets and Granite Countertops. New Interior Grey Paint in 2022 and Modern Laminate Flooring in 2020.This Home is a Must-See. Move in Ready! Just Minutes to I-10, Westpark Tollway, 99, Shopping and Restaurants. Zoned to Katy ISD and Award Winning Schools! All measurements are approximate, buyers agent to verify.' ,`Acres` = '0.2089' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEVEN MEADOWS SEC 6, BLOCK 5, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HOLLAND ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Seven Meadows' ,`TaxAmount` = '9466' ,`TaxRate` = '2.5145' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386025' WHERE `Matrix_Unique_ID` = '209745690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:54:30.577' ,`MLSNumber` = '31445997' ,`ListAgentFullName` = 'Wallace Everitt' ,`ListOfficeName` = 'Southwest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.041844' ,`Longitude` = '-95.459097' ,`PhotoCount` = '41' ,`PostalCode` = '77388' ,`RoomCount` = '5' ,`ListPrice` = '265500.00' ,`Status` = 'Active' ,`StreetName` = 'Candle Pond' ,`StreetNumber` = '3115' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SECURE, GATED COMMUNITY. 2 BR WITH STUDY OFF MASTER BR. WOULD MAKE GREAT NURSERY OR 3RD BR.\r\nNEW A/C IN 2019 WITH TO 17 SEER. NEW GARAGE DOOR OPENER. 3 YEAR CHOICE HOME WARRANTY PURCHASED RECENTLY.\r\nREFRIGERATOR AND WASHER AND DRIER INCLUDED.' ,`Acres` = '0.1331' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 CANDLELIGHT PARK ESTATES SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5797' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Candlelight Park Estates Sec 0' ,`TaxAmount` = '4178' ,`TaxRate` = '2.124' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386026' WHERE `Matrix_Unique_ID` = '210399107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:58:56.837' ,`MLSNumber` = '48427584' ,`ListAgentFullName` = 'Kimberly Shaw' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Kimberly Shaw' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.466954' ,`Longitude` = '-95.339406' ,`PhotoCount` = '50' ,`PostalCode` = '77578' ,`RoomCount` = '9' ,`ListPrice` = '599995.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Louisiana' ,`StreetNumber` = '7023' ,`StreetSuffix` = 'Street' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Finally, the Ranchette you\'ve been waiting for!! This one truly has it all! Incredible home remodel in 2020 (see attached document). Roof, Windows, Septic, Stalls, Chicken Coop, Fencing, RV and Trailer Parking, you name it, it\'s likely just been added! Tastefully re-designed home offers 3 bedrooms & 3 full baths along w/a HUGE bonus room w/ private bath & walk-in closet perfect for a game room/office, in-law area or 4th bedroom. Wide open main living areas w/ an absolutely HUGE kitchen! Double ovens, pot filler, walk in pantry, center island w/ seating for 5 & so very much more! Outside is well thought out for the ranch home w/ 3 Exterior 220 plugs for horse trailers, hot tub and RV. 2 Pasture areas with automatic water trough, 4 nicely sized horse stalls & room for a future arena! Oh! Did I mention that there\'s also a 40x40 shop with 4 Roll up doors & a loft? Back yard of home is dog-fenced. Huge rear porch just waiting for those get-togethers! Don\'t walk, RUN! This is it!' ,`Acres` = '4.09' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MANVEL PLAZA (A0283 H T & B R R), LOT 47, ACRES 4.090' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '178160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Manvel Plaza' ,`TaxAmount` = '7840' ,`TaxRate` = '2.7874' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386026' WHERE `Matrix_Unique_ID` = '210550274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:51:13.070' ,`MLSNumber` = '40166757' ,`ListAgentFullName` = 'Osaan Ronding' ,`ListOfficeName` = 'The Listing Firm' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.502226' ,`Longitude` = '-95.181988' ,`PhotoCount` = '47' ,`PostalCode` = '77546' ,`RoomCount` = '6' ,`ListPrice` = '869900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak' ,`StreetNumber` = '102' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained custom home with upgrades galore! Amazing Backyard Oasis w/ heated pool & spa, covered patio w/ outdoor kitchen, fireplace, beverage cooler, outdoor shower and so much more! 5 bedroom 3.5 baths in the main house w/ primary bedroom downstairs. Open living w/ large granite island in kitchen w/ SS appliances & under counter ice machine. Huge gameroom upstairs w/ new carpet throughout. Spacious secondary bedrooms & walk-in closets, each w/ Jack & Jill baths. Garage apartment w/ partial kitchen & full bath! 4th car garage space has been converted to a workshop. 3 New HVAC systems! Automatic driveway gate w/ extra parking for trailers and boats. Easy access to 518 & I-45. This is a must see!' ,`Acres` = '0.566' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 151 PAGE 11 LOT 1 BLK 2 POLLY OAKS SUB' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '24655' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Polly Oaks Sub 93' ,`TaxAmount` = '11611' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386026' WHERE `Matrix_Unique_ID` = '210710515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:23:28.320' ,`MLSNumber` = '90446314' ,`ListAgentFullName` = 'Vinh Dang' ,`ListOfficeName` = 'Central Metro Realty' ,`SellingAgentFullName` = 'Kleber Gonzalez' ,`SellingOfficeName` = 'R3 Yes! Real Estate, LLC' ,`Latitude` = '29.925423' ,`Longitude` = '-95.682810' ,`PhotoCount` = '50' ,`PostalCode` = '77095' ,`RoomCount` = '8' ,`ListPrice` = '319900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Prospect Meadows' ,`StreetNumber` = '17502' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find Waterfront Home in the heart of Cypress area across from TOWNE LAKE BOARDWALK. Zoned to top ranking schools. Easy access 290, 99, & I-10. Medical facilities, restaurants, gyms, retail shops, major grocery stores are within two miles radius. Community resort-style amenities with miles of waterfront walking trails and gorgeous parks. Beautiful remodeled kitchen with multiple lake views, abundance of natural light. Spacious backyard will fit a large pool looking out to lake, perfect for entertaining guests at a summer cookout. FLEX SPACE can be used for home office with lake view. Many upgrades done in December 2020, professional fresh paint, elegant Quartz countertop throughout home, new backsplash, brand new 16 SEER HVAC system, new dishwasher, contemporary light and plumbing fixtures, garage door opener with remote. NEVER FLOODED! Million Dollars Homes being built surrounding the area. Low tax rate.' ,`Acres` = '0.124' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 60 BLK 3 CANYON LAKES VILLAGE SEC 3 AMEND' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WOODARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Canyon Lakes Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386026' WHERE `Matrix_Unique_ID` = '210937135' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:29:34.057' ,`MLSNumber` = '98978816' ,`ListAgentFullName` = 'Stephanie Nelson' ,`ListOfficeName` = 'Prime Properties' ,`SellingAgentFullName` = 'Michelle Gonzales' ,`SellingOfficeName` = 'BHHS Tiffany Curry & Co., REALTORS' ,`Latitude` = '29.530277' ,`Longitude` = '-95.171202' ,`PhotoCount` = '17' ,`PostalCode` = '77546' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Regata Run' ,`StreetNumber` = '3030' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1932' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You don\'t want to miss this one! Pool, hot tub, covered back patio. Heater/Fan unit 2022 and comes with 2 free maintenance checks, Kitchen remodel 2021 with so many pull out drawers inside cabinets, built in racks, Appliances 2021 (oven is also an air fryer), gas cooktop, Bar in kitchen with wine refrigerator and a separate coffee bar, Windows 2019, Roof 2019, Pool filter 2019, freshly painted, window treatments stay, washer, dryer, refrigerator stays, back patio couch stays, outside storage sheds stay, NO FLOODING, kitchen open to family room, tall ceilings, stone fireplace, gorgeous backyard views, split plan, walk-in primary closet, garden tub, separate shower, dual vanities, great location close to restaurants, retail, freeway, easy drive to Galveston' ,`Acres` = '0.171' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 HERITAGE PARK SEC 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7449' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '352' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park' ,`TaxAmount` = '5069' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386026' WHERE `Matrix_Unique_ID` = '210965809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:03:22.343' ,`MLSNumber` = '78095049' ,`ListAgentFullName` = 'David Herzog' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834306' ,`Longitude` = '-95.434181' ,`PhotoCount` = '37' ,`PostalCode` = '77018' ,`RoomCount` = '4' ,`ListPrice` = '1497500.00' ,`Status` = 'Active' ,`StreetName` = 'Martin' ,`StreetNumber` = '1333' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just finished! Herzog Homes proudly presents a new custom home in sought-after Oak Forest Elementary! Tastefully contemporary, the wide-open floor plan is spaciously designed for family living & entertaining. The generous Primary Suite includes a beamed high ceiling & large sitting room, 2 large custom walk in closets, romantic gas FP, and a primary bathroom draped in marble. The custom kitchen boasts Thermidor built-in appliances, quartz tops, butler\'s pantry, a wine room housed in hand-designed wrought iron. The living room is spacious with a gas FP, cabinetry, huge windows looking into a spacious fenced yard w very large covered patio. You will also notice the wide plank hardwood is almost everywhere. Atop the wood-stained stairs, lined with a custom iron railing, you will find the Primary Suite, 3 generously sized bedrooms, 2 more full baths, a walk-in laundry & a huge game room with raised ceilings. It is our pleasure to share our new property with you.' ,`Acres` = '0.168' ,`Area` = '9' ,`BuilderName` = 'Herzog Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 32 OAK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Forest Sec 03' ,`TaxAmount` = '9229' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386027' WHERE `Matrix_Unique_ID` = '211016557' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:37:00.243' ,`MLSNumber` = '10888384' ,`ListAgentFullName` = 'Vania Delgado' ,`ListOfficeName` = 'Wiseman Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830472' ,`Longitude` = '-95.329081' ,`PhotoCount` = '26' ,`PostalCode` = '77016' ,`RoomCount` = '4' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Hirsch' ,`StreetNumber` = '7811' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2043' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this new construction home Built by TC BUILDERS! This 4 bedroom, 2 1/2bath home has a beautifully designed floor plan. Come see the soaring ceilings and open kitchen that is perfect for entertaining. Beautiful tile flooring throughout the house, the primary bedroom has a walk-in closet, and double sinks in the primary bath. The backyard has ample space with a covered patio. The home has an immaculate driveway and a beautiful wrought front iron gate.' ,`Acres` = '0.1722' ,`Area` = '2' ,`BuilderName` = 'TC Builders, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 41A CRANFORD PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PAIGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cranford Place' ,`TaxAmount` = '591' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386027' WHERE `Matrix_Unique_ID` = '211091240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:37:00.800' ,`MLSNumber` = '18126283' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711917' ,`Longitude` = '-95.853727' ,`PhotoCount` = '22' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '593909.00' ,`Status` = 'Active' ,`StreetName` = 'Kenton Place' ,`StreetNumber` = '5222' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIKE NEW... Stunning One Story home in the heart of Cross Creek Ranch Master Planned Community. Featuring 4 bedrooms, 3 bathrooms, Game Room, Private study, PLUS a 3 CAR GARAGE- this home will not disappoint. Formal entry with tall ceilings, tile flooring, and a home office with new double doors are just some of the details you will notice upon entering. This beautiful floorplan offers a spacious living area with tall ceilings and a gas fireplace. Well laid out open kitchen with butler pantry, stainless steel appliances, under cabinet lighting, and center island. Expansive primary retreat with en-suite bath featuring dual sinks, separate shower, and soaking tub. The home backs to green space and walking trails. Oversized back and side yard. ROOM FOR A POOL! Fresh paint throughout! Light and Bright! New flooring in all bedrooms. Cross Creek Ranch features miles of walking and biking trails, community pools, tennis courts, pickle ball courts and other amenities. Exemplary KISD!' ,`Acres` = '0.2502' ,`Area` = '36' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK BEND AT CROSS CREEK RANCH SEC 6, BLOCK 1, LOT 13' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '10897' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creek Bend At Cross Creek Ranch Sec 6' ,`TaxAmount` = '12411' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386027' WHERE `Matrix_Unique_ID` = '211194885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:17:13.140' ,`MLSNumber` = '32417042' ,`ListAgentFullName` = 'Frank Liu' ,`ListOfficeName` = 'Lovett Realty, Inc' ,`SellingAgentFullName` = 'Ashley Heacock' ,`SellingOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`Latitude` = '29.754488' ,`Longitude` = '-95.498807' ,`PhotoCount` = '14' ,`PostalCode` = '77057' ,`RoomCount` = '7' ,`ListPrice` = '1150000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wood Hollow' ,`StreetNumber` = '1254' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3819' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION, 4 BEDROOMS, 4.5 baths, 3 CAR GARAGE. THIS HOME IS UNDER CONTRACT, BUT WE HAVE ANOTHER 4 BEDROOM, 3 CAR GARAGE HOME UNDER CONSTRUCTION. WALK TO WHOLE FOODS, Gated lock and leave lifestyle in a fabulous Tanglewood/Memorial location within walking distance to Whole Foods, shopping, dining, and Second Baptist Church. Gated luxury lifestyle with a community pool. INSTALLED ELEVATOR. Roof top terrace with an outdoor fireplace in addition to a small fenced in yard space for your furry friends. Chef\'s kitchen features custom inset cabinetry, 48\" range with double ovens, 6 burners & a griddle. Wonderful open floor plan for entertaining with 12 ft ceilings in the living areas. Luxury finishes and plenty of Eco-Hip \"green\" features for low maintenance living. Wide plank wood flooring throughout, no carpet. Pictures are of similar homes by builder.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'Spyglass Homes, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Briargrove' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 TANGLEWOOD HOLLOW' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2395' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Hollow' ,`TaxAmount` = '2380' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386027' WHERE `Matrix_Unique_ID` = '211312021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:19:32.553' ,`MLSNumber` = '83910460' ,`ListAgentFullName` = 'Frank Liu' ,`ListOfficeName` = 'Lovett Realty, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.754537' ,`Longitude` = '-95.498681' ,`PhotoCount` = '13' ,`PostalCode` = '77057' ,`RoomCount` = '4' ,`ListPrice` = '849900.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Hollow' ,`StreetNumber` = '1248' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WALK TO WHOLE FOODS, fabulous Tanglewood/Memorial location within walking distance to Whole Foods, numerous restaurants, shopping, & Second Baptist Church. This wonderful new construction single family home is located in a gated luxury lifestyle community of 39 homes with a COMMUNITY POOL. Chef\'s kitchen features high end 48\" range with double ovens, 6 burners, & a griddle, & custom double stacked cabinetry with soft close drawers and doors. Wonderful open floor plan for entertaining with 12ft ceilings in the living area. Luxury finishes and plenty of Eco-Hip \"green\" features for low maintenance living. 4th floor game room could be used as a 4th bedroom, INSTALLED ELEVATOR included, & wood flooring throughout, no carpet.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'Spyglass Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Briargrove' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 1 TANGLEWOOD HOLLOW' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2395' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Hollow' ,`TaxAmount` = '2380' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386027' WHERE `Matrix_Unique_ID` = '211321092' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:54:04.183' ,`MLSNumber` = '12873840' ,`ListAgentFullName` = 'Karina Wade-Gledhill' ,`ListOfficeName` = 'Seabrook Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.575398' ,`Longitude` = '-95.052585' ,`PhotoCount` = '39' ,`PostalCode` = '77586' ,`RoomCount` = '14' ,`ListPrice` = '604500.00' ,`Status` = 'Active' ,`StreetName` = 'Harborcrest' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Seabrook' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FROM THE MOMENT YOU WALK-IN YOU WILL NOTICE AN ELEGANT HOME WITH BEAUTIFUL MODERN FINISHES, AND STUNNING NATURAL LIGHTING. HOME IS COMPLETELY UPDATED FROM TOP TO BOTTOM INCLUDING NEW ROOF, NEW DRIVEWAY, NEW A/C, NEW WINDOWS, NEW FLOORING, NEW KITCHEN, NEW BATHROOMS, NEW APPLIANCES, NEW FIXTURES, NEW PAINT ETC. THIS 3,836 SQFT., 4 BEDROOM, 3.5 BATH, HOME HAS AN 11,884 SQFT. FENCED IN PROPERTY WITH A WOODEN OUTDOOR PATIO. THE NEW KITCHEN HAS A MUST SEE WALK IN PANTRY, QUARTZ COUTERTOPS, BREAKFAST BAR, AND EASY ACCESS TO THE OVERSIZED LAUNDRY ROOM AND HALF BATHROOM. THE FAMILY ROOM HAS A BRICK GAS FIRE PLACE, AND FRENCH DOORS OPEN UP INTO THE ADDITIONAL LIVING AREA.THE UPSTAIRS PRIMARY BEDROOM FEATURES A VERY LARGE CUSTOM WALK-IN CLOSET WITH BEAUTIFUL LIGHTING, AND MUST SEE PRIMARY BATHROOM. THIS HOME HAS NEVER FLOODED. THIS HOME IS LOCATED IN THE DESIRABLE WATERFONT COMMUNITY OF TIMBER COVE IN 77586, WITH PARKS, WALKING TRAILS, BOATING AND FISHING ALL CLOSE BY.' ,`Acres` = '0.2728' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 4 TIMBER COVE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11884' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Cove Sec 01' ,`TaxAmount` = '8135' ,`TaxRate` = '2.279' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386027' WHERE `Matrix_Unique_ID` = '211333665' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:16:10.460' ,`MLSNumber` = '95423624' ,`ListAgentFullName` = 'Brad Bortz' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.913890' ,`Longitude` = '-95.653572' ,`PhotoCount` = '33' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '333000.00' ,`Status` = 'Active' ,`StreetName` = 'Aber Trail' ,`StreetNumber` = '8931' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Aberdeen Green; a wonderful family-oriented community, convenient to all your needs. This beautiful home sits on the corner of a quiet cul-de-sac. The vaulted family room lets the Sun Shine In! Large windows overlooking the paver patio drench the home with natural light. Cozy up to your stone, wood-burning & gas, fireplace on those chilly Houston nights. Offering a large formal dining room for those family holiday gatherings, and a large breakfast room off the kitchen for your everyday gastronomic enjoyment. The first-floor primary BR has an en-suite bath with a separate shower, double vanities, and a very spacious walk-in closet. On the second floor, you will find two oversized bedrooms, a full bath, and a sizeable game room, workout area, or perhaps a playroom for the kids. Just a 5-minute walk to the lake and walking path; just across the street from the community swimming pool, clubhouse, and play areas. Freshly painted, New carpeting. NEVER FLOODED. PRIVATELY OWNED.' ,`Acres` = '0.169' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 ABERDEEN GREEN SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BIRKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aberdeen Green Sec 03' ,`TaxAmount` = '6352' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386028' WHERE `Matrix_Unique_ID` = '211388201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:14:46.530' ,`MLSNumber` = '27782577' ,`ListAgentFullName` = 'Travis Hanus' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.686900' ,`Longitude` = '-95.522181' ,`PhotoCount` = '15' ,`PostalCode` = '77340' ,`RoomCount` = '6' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Mosley' ,`StreetNumber` = '134' ,`StreetSuffix` = 'Lane' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OWNER AGENT. Location, location, location! This 4 bedroom 2 bath home is only 1 mile from I45 and Highway 19 providing great access. Open concept kitchen with oversized pantry, gas stove/range, granite countertops, and breakfast bar overlooking the living room. Back door leads to a privacy-fenced back yard with a serene view of the forest, no back neighbors! Master bedroom has carpet and an en-suite bathroom with tile flooring, granite countertop vanity, soaking tub, separate shower, and large walk-in closet. Large closets in the 3 other carpeted bedrooms. New paint (interior and exterior) and carpet! House is empty and move-in ready!' ,`Acres` = '0.201' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'THOREAU WOODS, LOT 4, ACRES .201' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8756' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Thoreau Woods' ,`TaxAmount` = '3931' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1664386028' WHERE `Matrix_Unique_ID` = '211459837' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:57:26.890' ,`MLSNumber` = '50736216' ,`ListAgentFullName` = 'Cary Stephens' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = 'Dena Hobbs-Lix' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.985425' ,`Longitude` = '-95.114876' ,`PhotoCount` = '27' ,`PostalCode` = '77532' ,`RoomCount` = '10' ,`ListPrice` = '339000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Papoose' ,`StreetNumber` = '1914' ,`StreetSuffix` = 'Trail' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED $10,000!! GREAT VALUE!! GREAT LOCATION!! Beautiful Newer house built in 2004!! NEW ROOF with 30 year shingles!! Great Curb Appeal with this White Austin Stone one-story with covered front porch that wraps around one corner of the house. NEVER FLOODED!! Spacious kitchen & breakfast room features granite counter tops, island, stainless appliances & breakfast bar that opens to the large family room with vaulted ceiling!! Windows have 2-inch blinds throughout. Large Master Bedroom! Master bath has jetted tub, separate shower, double sinks & large walk-in closet. 2 car garage has been partially converted for those needing a 4th bedroom, but lots of storage is still available! Could easily convert back to a 2 car garage if desired! Over-sized driveway perfect for additional parking! Drive thru double gate to the large, fenced back yard. Oversized 20 x15 covered back patio with ceiling fan!' ,`Acres` = '0.2927' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 183 BLK 20 INDIAN SHORES SEC 8' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '12750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Indian Shores Sec 08' ,`TaxAmount` = '5445' ,`TaxRate` = '2.5873' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386028' WHERE `Matrix_Unique_ID` = '211611085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:27:08.100' ,`MLSNumber` = '95742110' ,`ListAgentFullName` = 'Rosalva Cardenas' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.557790' ,`Longitude` = '-95.409904' ,`PhotoCount` = '15' ,`PostalCode` = '77584' ,`RoomCount` = '9' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashbrook Lane' ,`StreetNumber` = '2902' ,`StreetSuffix` = '' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME SWEET HOME in a CORNER LOT!\r\nVery close to school! Quiet Scenic spot in in a sought-after Shadow Creek Ranch Neighborhood. Lots of bike and running trails.\r\nImpressive living space is created by a welcome interior entrance, Updated kitchen with Granite countertops.\r\nFresh interior paint. \r\nInviting HUGE backyard which boasts a beautifully manicured area, Lovely and serene , the perfect spot to hast family BBQ\'s.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Shadow Creek Ranch SF-30 Pearland Block 2,Lot 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6952' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1069' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'BROTHERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386028' WHERE `Matrix_Unique_ID` = '211669281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:57:22.693' ,`MLSNumber` = '21059270' ,`ListAgentFullName` = 'Pamela Smartt' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727374' ,`Longitude` = '-98.165845' ,`PhotoCount` = '33' ,`PostalCode` = '78132' ,`RoomCount` = '12' ,`ListPrice` = '549500.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Cascade' ,`StreetNumber` = '514' ,`StreetSuffix` = '' ,`City` = 'New Braunfels' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new favorite place! This home is ready to host your life and all that comes with it. A beautiful brick and rock face is one of the many gems this house possesses. This spacious home boasts 4 bedrooms and 3 baths. It also features an office, game room, formal dining, breakfast area, open living and kitchen space, and laundry room, with high ceilings and multiple windows for a bright and airy feel throughout. Your low maintenance yard is complete with a back patio and decking. Close to all the amenities of New Braunfels, the esteemed Oak Run neighborhood has many sought after features to make this home your dream come true!' ,`Acres` = '0.21' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'OAK RUN 19, BLOCK 3, LOT 144' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9148' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '142 - New Braunfels' ,`SchoolElementary` = '' ,`SchoolHigh` = 'NEW BRAUNFELS HIGH SCHOOL' ,`SchoolMiddle` = 'OAKRUN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Run 19' ,`TaxAmount` = '9248' ,`TaxRate` = '2.0267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386028' WHERE `Matrix_Unique_ID` = '211808262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:07:00.740' ,`MLSNumber` = '49385337' ,`ListAgentFullName` = 'James Evans' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.660594' ,`Longitude` = '-95.683931' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '598000.00' ,`Status` = 'Active' ,`StreetName` = 'Belshill' ,`StreetNumber` = '10615' ,`StreetSuffix` = 'Street' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '3118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has it ALL!! From lights in the trees to underground french drains, this house is equipped with everything you could need. This house is a 3/4 bedroom with all beds downstairs including a downstairs game room. Upstairs is a generous sized flex space with half bath which has many options. Other features in this house include high ceilings, outdoor kitchen, plantation shutters, LED lighting, security cameras, water softener, 2 side gates, paved pathways and more! As you enter you are greeted by a wonderful rotunda and a home office to your right, with brand new French doors. The gathering spot for friends and family would be the kitchen/family room combo. With tall ceilings, updated lighting this area welcomes everyone. The kitchen has 2 islands, both with ample gathering space. When you are ready to end the day you can head out to the covered patio and relax before heading to the primary suite. This bedroom has it all from the size, amount of natural light and tall ceilings.' ,`Acres` = '0.1907' ,`Area` = '37' ,`BuilderName` = 'Plantation' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 23, BLOCK 2, LOT 7' ,`LotDesciption` = 'Other' ,`LotSize` = '8306' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MADDEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aliana Sec 23' ,`TaxAmount` = '11179' ,`TaxRate` = '2.9329' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386028' WHERE `Matrix_Unique_ID` = '211862069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:53:14.763' ,`MLSNumber` = '44679650' ,`ListAgentFullName` = 'Victorino Cortez' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.982512' ,`Longitude` = '-95.194388' ,`PhotoCount` = '21' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'English Brook' ,`StreetNumber` = '12203' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1791' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1-story home completely remodeled. Kitchen features open floor plan with new stainless steel appliances, granite countertops with subway tile backsplash. New flooring throughout the entire home with fresh paint. The home is equipped with new roof, AC/Furnace, water heater, outdoor lighting and gutters. Has high ceilings throughout, refrigerator stays, zoned to highly acclaimed Humble ISD schools, and close to shopping, dining, and entertainment.' ,`Acres` = '0.1205' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 5 CLAYTONS CORNER SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Claytons Corner Sec 01' ,`TaxAmount` = '5275' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386029' WHERE `Matrix_Unique_ID` = '212134186' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:30:39.467' ,`MLSNumber` = '28322364' ,`ListAgentFullName` = 'Jojo Tharayil' ,`ListOfficeName` = 'Excel Realty Co' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560348' ,`Longitude` = '-95.548730' ,`PhotoCount` = '17' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'King Cotton' ,`StreetNumber` = '4106' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2586' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT BIG KITCHEN WITH ISLAND AND BREAKFAST AREA, FAMILY ROOM, FORMAL LIVING AND DINING ROOMS, FIREPLACE, HUGE BACKYARD. MASTER DOWNSTAIRS AND ALL OTHER BEDROOMS UP. GREAT COMMUNITY. YOU WILL WANT TO COME HOME!' ,`Acres` = '0.1736' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PALMER PLNT-LAKE OLYMPIA SEC 1, BLOCK 4, LOT 14, R/P' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7561' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Olympia Sec 1' ,`TaxAmount` = '6252' ,`TaxRate` = '2.81' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386029' WHERE `Matrix_Unique_ID` = '212170778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:15:56.033' ,`MLSNumber` = '88130377' ,`ListAgentFullName` = 'Armando Espinosa Jr' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.247228' ,`Longitude` = '-95.444186' ,`PhotoCount` = '38' ,`PostalCode` = '77302' ,`RoomCount` = '12' ,`ListPrice` = '304850.00' ,`Status` = 'Active' ,`StreetName` = 'Brandon' ,`StreetNumber` = '540' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2643' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderfully updated home in the beautiful River Plantation community of Conroe! This spacious 4 bedroom home sits on an oversized corner lot with a gated driveway, front and back covered patios, 2 car garage plus additional covered parking! Formal dining, formal living room and family room with remodeled kitchen are perfect settings for holiday gatherings. White shaker style cabinets, granite countertops and all stainless steel appliances. Trending paint colors and ceramic tile flooring throughout the house with NO CARPET. Community amenities include a pool, tennis, basketball, playground, parks and 27 hole golf course!' ,`Acres` = '0.2977' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER PLANTATION 04, LOT 113' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '12967' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '213' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River Plantation 04' ,`TaxAmount` = '3897' ,`TaxRate` = '2.1648' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386029' WHERE `Matrix_Unique_ID` = '212193957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:56:35.987' ,`MLSNumber` = '28013523' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.436360' ,`Longitude` = '-95.418933' ,`PhotoCount` = '6' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '849392.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Park' ,`StreetNumber` = '4718' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3845' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 28013523 - Built by Drees Custom Homes - January completion! ~ Walking into the Leighton you will find a secondary bedroom with a private bath to your left. Walking through the foyer the Study will be to your right. The open living triangle features a cozy fireplace opposite the large serving island. With ample cabinets and counter space, plus a butler\'s pantry and walk-in pantry, the Leighton is perfect for entertaining. Whether you prefer games and movies or dining al fresco, you have plenty of choices with game and media rooms, plus a large covered porch.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot - 26 / Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12265' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double 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` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386029' WHERE `Matrix_Unique_ID` = '212216610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:21:03.553' ,`MLSNumber` = '73603318' ,`ListAgentFullName` = 'Livee Gao' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775583' ,`Longitude` = '-95.418632' ,`PhotoCount` = '15' ,`PostalCode` = '77007' ,`RoomCount` = '6' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Inker' ,`StreetNumber` = '5408' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated, well-kept home on corner lot. Spacious 2 story home has 3 bdrm at 1st floor. living area and master at 2nd floor. Granite countertop. Wood floor. New master shoer, floor. 9/2022 water heater, kitchen sink, disposal, carpet and paint. 2 car garage. Washer, dryer and refr, are included.' ,`Acres` = '0.0562' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 1 CONTEMPORARY PARK SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '2450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Contemporary Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386029' WHERE `Matrix_Unique_ID` = '212335427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:30:36.143' ,`MLSNumber` = '76371579' ,`ListAgentFullName` = 'Danny Vu' ,`ListOfficeName` = 'Danny Vu Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804098' ,`Longitude` = '-95.146636' ,`PhotoCount` = '20' ,`PostalCode` = '77530' ,`RoomCount` = '7' ,`ListPrice` = '199990.00' ,`Status` = 'Active' ,`StreetName` = 'Stevenage' ,`StreetNumber` = '1535' ,`StreetSuffix` = 'Lane' ,`City` = 'Channelview' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1647' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICED TO SELL - This stunning home has completely renovated inside and out featuring 3 bedrooms and 2 and 1/2 baths plus a HUGE bonus room (2 car garage conversion) that can be media room, gym, additional living room, or another bedroom. Beautiful tile floorings on the first floor and carpet on the 2nd floor, SS appliances, gorgeous sparkling Quartz countertops with stunning backsplash, electric fireplace with remote, fully fenced large backyard and many more... Everything is new including new roof, HVAC, SS range, water heater, insulation, etc...The house is not in the flood zone has never been flooded. Easy access to BW8 and I10. Come see it today before it\'s gone tomorrow..' ,`Acres` = '0.1337' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 8A & 9 BLK 1 N PT OF LT 8 & S PT OF LT 9 STERLING GREEN' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '270' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Green Sec 09' ,`TaxAmount` = '1654' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386029' WHERE `Matrix_Unique_ID` = '212384764' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:30:06.677' ,`MLSNumber` = '12204715' ,`ListAgentFullName` = 'Durran Starks' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.490802' ,`Longitude` = '-95.387759' ,`PhotoCount` = '39' ,`PostalCode` = '77578' ,`RoomCount` = '5' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Basin Park' ,`StreetNumber` = '4238' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3133' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop your car HERE IT IS! One of Shea Homes recently built property is now available. Beautiful 2-story stucco exterior, 3-car garage, with 4 bedrooms, 3 baths. Home office with French doors set at entry with 10-foot ceiling. The fabulous kitchen comes with built-in oven, a 5-burner gas cooktop and an oversized island with easy care granite countertop and cabinets galore. An abundance of natural light throughout the home. Dining area flows into family room with wall of windows and 20 ft ceiling. Primary suite includes hallway entry to the En-suite bath with dual vanities, garden tub, separate glass-enclosed shower and large walk-in closet. Tons of living space upstairs connected to spacious bedrooms with walk-in closets. Oversize covered backyard patio. With over $20,000 worth of upgrades and NO BACK NEIGHBORS this one won\'t last long...' ,`Acres` = '0.186' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEL BELLO LAKES SEC 3 (A0460 HT&BRR) (MANVEL) BLK 2 LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`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,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Bello Lks' ,`TaxAmount` = '17278' ,`TaxRate` = '3.7394' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386030' WHERE `Matrix_Unique_ID` = '212419719' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:58:16.030' ,`MLSNumber` = '17638944' ,`ListAgentFullName` = 'Jenny Wang' ,`ListOfficeName` = 'JWang Properties' ,`SellingAgentFullName` = 'Yasir Zulfiqar' ,`SellingOfficeName` = 'Texas Tier Realty' ,`Latitude` = '29.601590' ,`Longitude` = '-95.644312' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '15' ,`ListPrice` = '799000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Chatham' ,`StreetNumber` = '222' ,`StreetSuffix` = 'Avenue' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4127' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A rare find in the heart of Telfair community, large corner lot & 1.5 stories. This showcase offers: custom grand entry, formal dining, spacious library/office with custom shelves & extended work room. Kitchen opens to living area with granite countertop, stainless appliances, butler station, gas range, ample cabinets & custom lighting. Living area with custom gas fireplace. Breakfast area with two sided windows & door to the covered patio with extended patio area. Primary bedroom with bay windows & 2 ensuite bedrooms on 1st level. Primary bathroom with duo vanities, custom cabinetry, Whirlpool tub & custom separate shower place. Walk-in closet with recent wood flooring & custom shelvings. 2nd level offers: game room. Media room that\'s converted into a professional Ballet Studio & another bedroom ensuite. Loaded upgrades as crown molding, wood flooring, pullout shelving system, dishwasher, commercial grade vent hood, lush landscaping front & back, etc. 3 car garage. Exemplary schools.' ,`Acres` = '0.3026' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TELFAIR SEC 23, BLOCK 1, LOT 42' ,`LotDesciption` = 'Corner' ,`LotSize` = '13183' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'CORNERSTONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Telfair Sec 23' ,`TaxAmount` = '17276' ,`TaxRate` = '2.8794' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386030' WHERE `Matrix_Unique_ID` = '212420232' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:55:56.923' ,`MLSNumber` = '20006993' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.443424' ,`Longitude` = '-95.401405' ,`PhotoCount` = '8' ,`PostalCode` = '77578' ,`RoomCount` = '6' ,`ListPrice` = '689531.00' ,`Status` = 'Active' ,`StreetName` = 'Columbus' ,`StreetNumber` = '4611' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 20006993 - Built by Drees Custom Homes - January completion! ~ The Maribelle is a highly desirable one-story plan. The open great room is spacious and bright, and includes a fireplace. The kitchen is a chef\'s dream with a working pantry, plus walk-in pantry and a generous island. The owner\'s suite is a perfect retreat with spa-like bath. This plane includes three secondary bedrooms and a media room, perfect for entertaining.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot - 28 / Block - 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10578' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double 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` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386030' WHERE `Matrix_Unique_ID` = '212428035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:26:29.200' ,`MLSNumber` = '70909088' ,`ListAgentFullName` = 'Courtney Jetelina' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876569' ,`Longitude` = '-95.657524' ,`PhotoCount` = '23' ,`PostalCode` = '77084' ,`RoomCount` = '3' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Placewood' ,`StreetNumber` = '16323' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1937' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! Upon entering, you will be delighted by the abundance of natural light and beautiful wood flooring complimented by light and bright walls. Spacious kitchen is a chef\'s dream with a large breakfast bar allowing additional seating, granite countertops, tile backsplash, gas range and walk-in pantry! Living area is open to the kitchen and dining making it the perfect space to entertain. Loft area upstairs can be utilized for a variety of different purposes! Retire to the effortless elegance of your large primary bedroom, offering a spa-experience ensuite with soaking tub, dual sinks, and separate shower! Two secondary bedrooms and conveniently located laundry room can be found down the hall. Large back yard backs to green belt--no back neighbors!' ,`Acres` = '0.0955' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 SOMMERALL SQUARE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4161' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LOWERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sommerall Square Sec 2' ,`TaxAmount` = '5825' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386030' WHERE `Matrix_Unique_ID` = '212484913' --> 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','212591424','1664386030','212591424','2022-09-28T07:08:24.170','92959238','Kelly Bell','CB&A, Realtors-Katy','','','29.758629','-95.876566','35','77494','9','439000.00','Active','Prairie Rose','29307','Court','Katy','3','0','4','2465','Single-Family','Gorgeous 1 story, 4-3-3 Car Garage on a Cul-de-Sac! Impressive entry with arched openings & high ceilings throughout. Updated, trendy lighting, open floorplan, beautiful soft white kitchen cabinets & large breakfast bar w/under-counter seating & pendant lighting. Gleaming granite counters, tumbled marble backsplash & stainless appliances. Floor-to-ceiling windows & lots of natural light. Home office at front of home w/french doors & a bay window. Primary bedroom at rear of home w/ensuite bath. All bedrooms are spacious w/ walk-in closets. Humongous covered patio with brick pavers, pavers on the extension patio and nice backyard landscaping. Large utility w/room for a freezer or fridge. Full sprinkler system & backyard plumbed with a gas line for a gas grill. This home has many upgrades & design features and is truly a showplace! 2.58 Tax Rate & great neighborhood amenities!','0.1514','30','Ravenna','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','Katy - Southwest','Central Gas','1','FIRETHORNE WEST SEC 12, BLOCK 3, LOT 24','Cul-De-Sac,Subdivision Lot','6597','Appraisal District','','800','0','','3','Convection Oven,Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','LINDSEY ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Firethorne West','7230','2.5848','Water District','2018','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:33:21.033' ,`MLSNumber` = '21718801' ,`ListAgentFullName` = 'Fiona Anderson' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.673196' ,`Longitude` = '-95.473399' ,`PhotoCount` = '33' ,`PostalCode` = '77096' ,`RoomCount` = '7' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Rutherglenn' ,`StreetNumber` = '5306' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning remodeled home located in the charming Meyerland subdivision within close proximity to all your city needs. This gorgeous 1 story boasts a completely remodeled interior with 3 bedrooms and 2 and a half bathrooms, a detached 2 car garage as well as gorgeous curb appeal and landscaping. This is open concept living at its best with the spacious living and dining area with several large windows to ensure the space is bright and inviting. Don\'t forget the convenient office area for all your work from home needs.The kitchen has quartz countertops, high end finishes and lots of storage space to delight any chef! Updates include - engineered hardwood floors throughout, new appliances, new electric, plumbing and HVAC systems and so much more! Over $200K in UPGRADES!! Large primary bedroom with spa like bath and patio doors leading to the stamped concrete patio - great for entertaining or to just enjoy the peaceful outdoors. Please schedule your private tour today!' ,`Acres` = '0.2204' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 21 MEYERLAND SEC 8 R/P F' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meyerland R/P F' ,`TaxAmount` = '6963' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386030' WHERE `Matrix_Unique_ID` = '212591703' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:17:44.793' ,`MLSNumber` = '45012130' ,`ListAgentFullName` = 'Yohan Adhitama' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690542' ,`Longitude` = '-95.067822' ,`PhotoCount` = '38' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '316900.00' ,`Status` = 'Active' ,`StreetName` = 'Robinson' ,`StreetNumber` = '912' ,`StreetSuffix` = 'Road' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one story house with 3 beds and one extra large room that can be turned into another bedroom. This wonderful home is sitting on large lot. Previous seller said the house is 2,644 sq. ft., the garage was converted into a recreational & separate laundry room. Nice size family room with fireplace, built-in shelf, and high ceiling. Cozy screen porch/patio. Oversize carport 24X48. Quiet neighborhood. Tons of upgrade. Fresh interior & exterior paint, new roof, new bathroom tile, new vinyl flooring, new Quartz countertops and backsplash, new light fixture, new cooktop, new kitchen sink & faucet, & new mirror. Easy access to Hwy. 225 & Hwy. 146. Schedule your showing today.' ,`Acres` = '0.4289' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lomax Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 410 411 & 412 BLK 11 BATTLEGROUND ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18681' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Battleground Estates Sec 02' ,`TaxAmount` = '5812' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386031' WHERE `Matrix_Unique_ID` = '212592742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:24:41.510' ,`MLSNumber` = '29014013' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.314752' ,`Longitude` = '-96.114490' ,`PhotoCount` = '2' ,`PostalCode` = '77488' ,`RoomCount` = '6' ,`ListPrice` = '139999.00' ,`Status` = 'Active' ,`StreetName` = 'Outlar' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Call soon and ask about Builder\'s current incentive***\r\nThis brand new Construction Energy-efficient home comes with a Low Tax rate! This home has a 5-step stairway leading to the front door and is placed on an elevated corner lot overlooking a large scenic view. Open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Vinyl plank flooring in living areas and plush carpet in the bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home. The Energy efficient features in the home will be reflected in your utility bills. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nReady for move-in. No HOA!\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1537' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SMITH GARDEN SPOT BLOCK 2 LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Smith Garden Spot' ,`TaxAmount` = '1386' ,`TaxRate` = '2.4334' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386031' WHERE `Matrix_Unique_ID` = '212612569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:13:41.780' ,`MLSNumber` = '45395765' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.183396' ,`Longitude` = '-96.275563' ,`PhotoCount` = '2' ,`PostalCode` = '77437' ,`RoomCount` = '2' ,`ListPrice` = '134999.00' ,`Status` = 'Active' ,`StreetName` = 'Roth' ,`StreetNumber` = '810' ,`StreetSuffix` = '' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Call soon and ask about Builder\'s current incentive***\r\nNew construction. Small touch-ups on paint needed then move-in ready! - This one-story plan with 2 bedrooms, 1 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with Espresso stained cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.165' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PHILLIPS BLOCK 2 LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7187' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Phillips' ,`TaxAmount` = '1901' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386031' WHERE `Matrix_Unique_ID` = '212621973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:06:34.767' ,`MLSNumber` = '76539270' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.181917' ,`Longitude` = '-96.279300' ,`PhotoCount` = '17' ,`PostalCode` = '77437' ,`RoomCount` = '3' ,`ListPrice` = '144999.00' ,`Status` = 'Active' ,`StreetName` = 'Sam' ,`StreetNumber` = '1307' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Call soon and ask about Builder\'s current incentive***\r\nNew construction ready for move-in immediately - This one story Plan with 3 bedrooms, 1 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with white cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1607' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SAM STREET SUBD BLOCK 1 LOT 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sam Street Sub' ,`TaxAmount` = '1748' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386031' WHERE `Matrix_Unique_ID` = '212627517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:56:00.653' ,`MLSNumber` = '18213292' ,`ListAgentFullName` = 'Ilich Ramirez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.869954' ,`Longitude` = '-95.742016' ,`PhotoCount` = '24' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Verbena Blossom' ,`StreetNumber` = '6410' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1398' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 6410 Verbena Blossom Trail in Katy, Texas. The home is in the wonderful Lantana neighborhood. The home is a Beazer Homes home that features energy efficiency and is incredibly quiet on the inside. The home is a 3 bedroom, 2 bathroom home with an extended covered patio which is fantastic especially because the home has no back neighbors. The interior is very well appointed and looks wonderful! Come inside and take a look at this fantastic home.' ,`Acres` = '0.124' ,`Area` = '25' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 LANTANA SEC 6' ,`LotDesciption` = 'Greenbelt,Other,Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '470' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lantana' ,`TaxAmount` = '4883' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386031' WHERE `Matrix_Unique_ID` = '212660159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:37:52.363' ,`MLSNumber` = '69680732' ,`ListAgentFullName` = 'Nayereh Tchamanzar' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.214094' ,`Longitude` = '-95.428288' ,`PhotoCount` = '15' ,`PostalCode` = '77385' ,`RoomCount` = '4' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Blackberry Lily' ,`StreetNumber` = '16871' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom home in lovely Montgomery Creek Ranch, close to neighborhood park and also to everything The Woodlands has to offer. Brand new porcelain flooring, brand new carpet, brand new granite, open concept kitchen, brand new Master bath walk-in shower. Updated upstairs bath, updated powder room, large game room, New roof.' ,`Acres` = '0.116' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S720806 - MONTGOMERY CREEK RANCH 06, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5055' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 06' ,`TaxAmount` = '5826' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386031' WHERE `Matrix_Unique_ID` = '212712240' --> 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','212720195','1664386032','212720195','2022-09-28T07:57:18.543','64293093','Ruben Hernandez','Apex Brokerage, LLC','','','29.805428','-95.789849','50','77493','11','365000.00','Active','Berkshire Elm','2154','Street','Katy','2','1','4','2702','Single-Family','The one you waited for all the summer is finally on the market! This Beautiful two story home is located on a large corner lot. High ceilings with open concept living. Home features,4 bedrooms,2.5 baths, two story entry & dining room. Spacious family room w/fireplace & built ins. Updated kitchen w/granite counters,stone backsplash & stainless steel appliances. Private study. Master suite on 1st floor w/garden tub,separate shower,framed mirrors & updated fixtures. Secret room hidden behind bookshelf in guest bedroom. Recently updated with fresh paint and carpet. This ons is A must see!','0.1648','25','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Katy - North','Central Gas','1','LT 1 BLK 2 WILLIAMSBURG PARISH SEC 8','Subdivision Lot','7178','Appraisal District','','450','0','','2','','0','','','Gas Range','','Composition','30 - Katy','WINBORN ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Williamsburg Parish Sec 08','6188','2.6083','Water District','2005','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','212794493','1664386032','212794493','2022-09-28T07:49:02.047','15728336','Susan Allen','Stanfield Properties','','','29.547345','-95.222969','25','77581','15','471352.00','Active','Briar View','2702','Drive','Pearland','3','1','4','3544','Single-Family','Beautiful and spacious 2-story home with a pool & spa in the desirable Briarglen subdivision in Pearland ISD! This Cervelle Homes design boasts a generously proportioned dining room, a flex use study or 5th bedroom with French doors, a lengthy family room with gas fireplace & impressive pool views, and a sunlit kitchen with pancake island, abundant pecan cabinetry, a walk-in pantry, & updated appliances. The first-floor master retreat showcases separate his & hers vanities & sinks, a spa tub, a separate shower, a 13\'x8\' walk-in closet, & French doors for a private exit to the pool & spa. Upstairs, find a sizeable game room, 3 secondary bedrooms, and 2 full baths. The fully fenced backyard boasts a custom iron gate, 3 car garage, & oasis pool with a large spa and easy-to-maintain rockscape. The home comes complete with a washer, dryer & fridge & updates in the last 2 years include a new pool filter & lights, a new roof, kitchen appliances, downstairs and upstairs AC, plus MORE!','0.202','5','Cervelle','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gaslog Fireplace','1','Pearland','Central Gas','1','BRIARGLEN SEC 3 (A0111 PERRY & AUSTIN)(PEARLAND) BLK 3 LOT 4','Subdivision Lot','8799','Appraisal District','','250','0','','3','Electric Oven','1','Gunite,In Ground','','Electric Cooktop','','Composition','42 - Pearland','RUSTIC OAK ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH EAST','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Briarglen Sec 3','8930','2.5552','Public Sewer,Public Water','1997','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:36:34.597' ,`MLSNumber` = '24349740' ,`ListAgentFullName` = 'Catina Anderson' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Joshua DeShong' ,`SellingOfficeName` = 'Myers The Home Buyers' ,`Latitude` = '29.855078' ,`Longitude` = '-95.743291' ,`PhotoCount` = '40' ,`PostalCode` = '77449' ,`RoomCount` = '11' ,`ListPrice` = '309000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bellaria Summit' ,`StreetNumber` = '21319' ,`StreetSuffix` = 'Trace' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location!! Location!! Location!!! *Katy near Fry Rd.*\r\nSTUNNING 2019 Well Kept Open Floor Plan 1Story 4Bedroom 2 Bath Home. Spacious Primary BDRM, Master Bath complete w/double vanity Separate Tub& Shower. 1bedroom can be used as an office .Laundry room inside home, Great recessed lighting throughout Home. Alarmed owned. Frontdoor keypad lock.FLOORING laminate. Carpet in bedrooms. KITCHEN-Island/Breakfast Bar w/stainless steel appliances, Kitchen/Dining Combo, Family Room, Attached 2 Car Garage with shelving, Nice size backyard with covered patio, No backyard neighbors fenced in, *LOW HOA* Minutes away from Entertainment, Restaurants, Shopping Stores, and Mall. Harris County. Call \r\nCatina Anderson to schedule a tour.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 JASMINE HEIGHTS SEC 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights Sec 13' ,`TaxAmount` = '5925' ,`TaxRate` = '2.7357' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386032' WHERE `Matrix_Unique_ID` = '212799809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:48:07.147' ,`MLSNumber` = '33635463' ,`ListAgentFullName` = 'David Tyer' ,`ListOfficeName` = 'Tyer Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.337777' ,`Longitude` = '-95.422280' ,`PhotoCount` = '24' ,`PostalCode` = '75835' ,`RoomCount` = '3' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 1500' ,`StreetNumber` = '218' ,`StreetSuffix` = '' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a great brick home located on CR 1500 about a mile from Loop 304. It offers an open concept between the kitchen, dining, and living areas that all have great laminate flooring, 3 nice sized bedrooms and full bathrooms. Outside you will find a nice covered back patio that faces the 1.7 +/- acres of land and a metal shop/storage building. This home is being sold in \"AS IS CONDITION\". CALL US TO SEE THIS PROPERTY.' ,`Acres` = '1.728' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'EAST RIDGE EST TR 38 1.728 AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '75272' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'East Ridge Estate' ,`TaxAmount` = '2152' ,`TaxRate` = '1.8725' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386032' WHERE `Matrix_Unique_ID` = '212819321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:28:35.100' ,`MLSNumber` = '13924661' ,`ListAgentFullName` = 'Pamela Elias' ,`ListOfficeName` = 'Cotton Properties' ,`SellingAgentFullName` = 'Kimberly Soderberg' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.133818' ,`Longitude` = '-95.525962' ,`PhotoCount` = '14' ,`PostalCode` = '77389' ,`RoomCount` = '7' ,`ListPrice` = '614900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Birdseye Maple' ,`StreetNumber` = '6822' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3486' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous one-story located in the master planned community of Auburn Lakes. This beautiful home is a MUST SEE! TALK ABOUT CURB APEAL! This meticulous home features 4 bedrooms with a study, game room, outdoor kitchen and a backyard to entertain year round! This house has it all with plantation shutters, high ceilings, custom light fixtures, separate vanities, custom kitchen cabinetry, a gorgeous courtyard entrance and an inviting backyard with a pool and a heated spa to entertain all of your guests! Minutes from The Woodlands Mall and easy access to Highway 99 and 45.' ,`Acres` = '0.2388' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 AUBURN LAKES RETREAT SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Auburn Lakes Retreat Sec 5' ,`TaxAmount` = '16482' ,`TaxRate` = '2.914' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386032' WHERE `Matrix_Unique_ID` = '212823677' --> 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','212839509','1664386032','212839509','2022-09-28T07:59:18.397','55973483','Theresa Burkham','BHGRE Gary Greene','','','30.352550','-95.591626','25','77316','10','348500.00','Active','Sunset','271','Path','Conroe','2','0','3','1993','Single-Family','Beautiful single-story home in Montgomery. Nice open floor plan with lots of space, large kitchen with lots of counter space and cabinets/storage, spacious primary bedroom with large walk-in closet, garden tub and separate shower and double sinks, office/extra bedroom, gas log fireplace, separate family room for watching movies or for the kids to play. Close to Lake Conroe and the amazing restaurants. Come see this beautiful home before it is gone!','0.1937','39','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Lake Conroe Area','Central Gas','1','TEJASCREEK 03, BLOCK 2, LOT 17','Subdivision Lot','8436','Appraisal District','','325','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','11 - Conroe','GORDON-REED ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox','Appraisal District','1','Traditional','Tejascreek','4991','2.1863','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:02:54.663' ,`MLSNumber` = '10118360' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.165775' ,`Longitude` = '-95.437800' ,`PhotoCount` = '1' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '144999.00' ,`Status` = 'Active' ,`StreetName` = 'Ash' ,`StreetNumber` = '729' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Call soon and ask about Builder\'s current incentive***\r\nThis home is a one-story Plan with 3 bedrooms, 1 bath home, an open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Vinyl plank flooring in living areas and plush carpet in the bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home. The Energy efficient features in the home will be reflected in your utility bills. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nNo HOA on this property! Ready for Move-in!\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.0868' ,`Area` = '5' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'JACKSON (ANGLETON), BLOCK 1, LOT 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3781' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jackson Angleton' ,`TaxAmount` = '89' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386032' WHERE `Matrix_Unique_ID` = '212852332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:32:10.367' ,`MLSNumber` = '98025529' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.170893' ,`Longitude` = '-95.436532' ,`PhotoCount` = '1' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '149999.00' ,`Status` = 'Active' ,`StreetName` = 'Miller' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Call soon and ask about Builder\'s current incentive***\r\nNew construction ready for move-in winter of 2022 or sooner - This one-story plan with 3 bedrooms, 1 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with white cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.0803' ,`Area` = '5' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'JACKSON (ANGLETON) BLK 3 LOT 11' ,`LotDesciption` = 'Other' ,`LotSize` = '3498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jackson Angleton' ,`TaxAmount` = '82' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386032' WHERE `Matrix_Unique_ID` = '212852434' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:45:46.067' ,`MLSNumber` = '39894389' ,`ListAgentFullName` = 'Monica Humphrey' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = 'Quynh Luong' ,`SellingOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`Latitude` = '29.943726' ,`Longitude` = '-95.268925' ,`PhotoCount` = '20' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '195000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Flamingo' ,`StreetNumber` = '15306' ,`StreetSuffix` = 'Park' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this quaint home in the well established Audubon Park in northeast Houston! Situated with easy access to Beltway 8, this three bedroom, 2 bath home features a brick fireplace, laminate and tile flooring throughout, and a primary bedroom with en suite bath. Garage has extra storage, and backyard is large and fully fenced. Living room features beams and built in bookcase. All appliances stay!' ,`Acres` = '0.154' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 6 AUDUBON PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '343' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'NORTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon Park Sec 01' ,`TaxAmount` = '3128' ,`TaxRate` = '2.7373' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386033' WHERE `Matrix_Unique_ID` = '212868012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:49:46.487' ,`MLSNumber` = '72412275' ,`ListAgentFullName` = 'Kristie Farmer' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813781' ,`Longitude` = '-95.535186' ,`PhotoCount` = '40' ,`PostalCode` = '77080' ,`RoomCount` = '8' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Moorberry' ,`StreetNumber` = '9618' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2290' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 9618 Moorberry, located in the prestigious Spring Shadows neighborhood. This beautiful Mid Century Modern home is a 1 story 4 bedroom with 2 full bathrooms. Beautiful ranch style layout with unique architectural design and detail like arched windows and entreeway. Floor to ceiling brick fireplace, Travertine tiled floors, level 3 granite in the kitchen counters backsplash, and the bathrooms. Open concept living area walls of windows to have perfect views of the backyard and an abundance of light. Expansive covered patio and beautiful mature trees for shade. Make your appointment today!' ,`Acres` = '0.2185' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 7A SPRING SHADOWS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '306' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING SHADOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Shadows Sec 05' ,`TaxAmount` = '9687' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386033' WHERE `Matrix_Unique_ID` = '212872994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:17:01.427' ,`MLSNumber` = '82104865' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.210214' ,`Longitude` = '-95.334818' ,`PhotoCount` = '13' ,`PostalCode` = '77302' ,`RoomCount` = '9' ,`ListPrice` = '586150.00' ,`Status` = 'Active' ,`StreetName` = 'Limoncello' ,`StreetNumber` = '17533' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Raised cathedral ceilings in the family/kitchen area and the owner\'s retreat.  This entertainer\'s dream home has beautiful vinyl wood flooring!  A chef\'s kitchen with mounted oven and 36\" vent hood, quartz countertops, lots of storage, great for the cook!    The secluded master suite features a super shower and huge closet.   Large backyard and covered patio completes this NEW DWH HOME! \r\n\r\n\r\n\r\n\r\nContact the David Weekley at ARTAVIA Team to learn about the amazing community amenities you’ll enjoy after moving into this lovely new home in Conroe, Texas!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot33 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386033' WHERE `Matrix_Unique_ID` = '212922724' --> 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','212954446','1664386033','212954446','2022-09-28T07:46:07.267','83479083','Nicholas Bruns','Sprout Realty','','','29.819860','-95.423508','36','77018','9','799900.00','Active','Autumndale Dr','3513','','Houston','4','1','4','3834','Single-Family','Located in the highly sought after, gated Shepherd Oaks community. This massive 4 bed, 4.5 bath home with large backyard and patio is sure to impress. Third floor of your dreams containing theater room with 110 inch projector screen and wet bar, almost 400 sq ft bonus room and large patio. First level contains open concept floor plan, including gourmet kitchen with large quartz island that overlooks spacious family room. Features include high ceilings, tons of natural light, crown molding, and hardwood floors. Meticulously well maintained; single owner. Second level contains fabulous master\'s suite with dual vanities, large garden tub, and separate shower with dual shower heads. Every bedroom has it\'s own full bathroom! Community area outside back gate with gazebo; ample guest parking. HOA fee covers yard maintenance and water. Right in the heart of Garden Oaks with plenty of parks, dining, shopping, and even a brewery and winery close by. Please ask about all the upgrades!','','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Oak Forest East Area','Central Gas,Zoned','1','LT 21 BLK 2 SHEPHERD OAKS','Subdivision Lot','3999','Appraisal District','','2700','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','GARDEN OAKS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Seller','3','Traditional','Shepherd Oaks','','','Public Sewer,Public Water','2016','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:27:49.727' ,`MLSNumber` = '43392663' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.976262' ,`Longitude` = '-95.970859' ,`PhotoCount` = '14' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '169999.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue B' ,`StreetNumber` = '2721' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1278' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Call soon and ask about Builder\'s current incentive***\r\nNew construction ready for move-in immediately - This one-story plan with 3 bedrooms, 2 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with espresso cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nOn a corner lot with no HOA!\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '' ,`Area` = '54' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAY CITY ORIGINAL TOWNSITE, BLOCK 84, LOT 1-2 (W-50\')' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay City Original Townsite' ,`TaxAmount` = '1347' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386033' WHERE `Matrix_Unique_ID` = '212955479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:19:30.187' ,`MLSNumber` = '98039262' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.188392' ,`Longitude` = '-96.274981' ,`PhotoCount` = '14' ,`PostalCode` = '77437' ,`RoomCount` = '3' ,`ListPrice` = '169999.00' ,`Status` = 'Active' ,`StreetName` = 'Greely' ,`StreetNumber` = '316' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Call soon and ask about Builder\'s current incentive***\r\nNew construction ready for move-in immediately - This two-story plan with 3 bedrooms, and 2.5 baths, is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with Espresso cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty \r\n—Follow link to the builder website to see floorplan—' ,`Acres` = '0.1579' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HARLEM LOT 35,36' ,`LotDesciption` = 'Other' ,`LotSize` = '6878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harlem' ,`TaxAmount` = '2394' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386033' WHERE `Matrix_Unique_ID` = '212956417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:56:03.160' ,`MLSNumber` = '52989151' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.303546' ,`Longitude` = '-96.063819' ,`PhotoCount` = '1' ,`PostalCode` = '77488' ,`RoomCount` = '3' ,`ListPrice` = '199999.00' ,`Status` = 'Active' ,`StreetName` = 'Cline' ,`StreetNumber` = '3614' ,`StreetSuffix` = 'Road' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Call soon and ask about Builder\'s current incentive***\r\nUnder construction and ready to be called home in the winter of 2022/23! This property will have a beautiful brick exterior, energy-efficient features that will be reflected in monthly utility bills, vinyl plank flooring, lush carpet in each bedroom, and an open floor plan with the kitchen open to the living room. Perfect for entertaining. Walking distance to a well-maintained park.\r\nWarranty: 1yr workmanship & materials, 2yr on plumbing, electrical, HVAC & other Mechanical Systems,10yr Major Structural components' ,`Acres` = '0.254' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAKER #1 LOT 7,8' ,`LotDesciption` = 'Other' ,`LotSize` = '11064' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Baker #1' ,`TaxAmount` = '966' ,`TaxRate` = '2.4334' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386034' WHERE `Matrix_Unique_ID` = '212956869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:54:33.960' ,`MLSNumber` = '44759905' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.320924' ,`Longitude` = '-96.111719' ,`PhotoCount` = '14' ,`PostalCode` = '77488' ,`RoomCount` = '4' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'N Spanish Camp' ,`StreetNumber` = '803' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1549' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Call soon and ask about Builder\'s current incentive***\r\nOverlooks a scenic farm view that must be seen in person! The property is expected to be completed winter of 2022. No HOA!\r\nThis 2 story plan with 4 bedrooms, 2 and a half baths, is energy efficient, with an open Concept Kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting, and vinyl plank flooring in the living room, dining, kitchen, and baths. Moen fixtures in a timeless chrome finish are placed throughout the home. All bedrooms are upstairs with lush carpeting in the bedrooms. 3 of the rooms have walk-in closets. Beautiful loft area at the top of the stairs. Perfect for reading or homework. Black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\n—Follow link to the builder website to see floorplan—\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1579' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WHARTON A.JACKSON BLK.52 LOT 2A' ,`LotDesciption` = 'Other' ,`LotSize` = '6878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wharton A jackson' ,`TaxAmount` = '2394' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386034' WHERE `Matrix_Unique_ID` = '212956995' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:58:07.230' ,`MLSNumber` = '3013820' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437035' ,`Longitude` = '-95.439379' ,`PhotoCount` = '20' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '471640.00' ,`Status` = 'Active' ,`StreetName` = 'Tioga View' ,`StreetNumber` = '1810' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2715' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Colina Home with 4 bedrooms, 2.5 baths, and study there\'s room for everyone! Large study located downstairs. Master bedroom located downstairs just outside the huge living room large enough for the whole family to get together for special occasions and holidays. Beautiful kitchen with upgraded 42\" cabinets, granite countertops, stainless steel appliances and is open to the oversized family room. The master suite features a large walk in closet and a spacious bath with a relaxing soaker tub and separate shower. Large game room located upstairs with a view to the first floor, 3 car garage included. 2\" faux wood blinds save you money and provide privacy from day one. The in wall pest control system protects your home.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 5 Sec 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11336' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386034' WHERE `Matrix_Unique_ID` = '212967875' --> 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','212968847','1664386034','212968847','2022-09-28T07:52:32.113','36949905','Osaan Ronding','The Listing Firm','','','29.543843','-95.354127','47','77584','4','319900.00','Active','Bentley','4103','Drive','Pearland','2','1','4','2320','Single-Family','Gorgeous updated Tudor style home no back neighbors. Beautiful curb appeal and close to fantastic schools, shopping & restaurants. Minutes away from highway for commuters. Entry to the home you are greeted by the formal living and dining room updated with amazing luxury vinyl floors. Fabulous open space for entertaining. Gourmet kitchen updated with stunning quartz counters, stainless appliances & even an oven with gas range and middle griddle. Kitchen is open to a spacious casual dining area with window seat as well as the family room. There is a breakfast bar too! Large family room with high ceilings, the gorgeous luxury vinyl floors and fabulous windows to the back yard. Downstairs primary bedroom with spa like updated en suite bathroom with two closets. Upstairs are 3 more bedrooms ... each with great space and additional bathroom. Wonderful backyard with gorgeous trees providing wonderful shade from the summer heat. Terrific space for the kids to play or for a family dog to run.','0.1791','5','','','','','Sellers Disclosure','1','Freestanding','1','Pearland','Central Gas','1','SOUTHWYCK, BLOCK 1, LOT 11 SEC 7, A0548 HT&BRR','Subdivision Lot','7802','Appraisal District','','530','0','','2','Gas Oven','0','','','Gas Range','','Composition','42 - Pearland','SILVERLAKE ELEMENTARY SCHOOL','GLENDA DAWSON HIGH SCHOOL','BERRY MILLER JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Southwyck','7240','2.5552','Water District','1985','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:05:26.950' ,`MLSNumber` = '30910159' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.313372' ,`Longitude` = '-96.109832' ,`PhotoCount` = '17' ,`PostalCode` = '77488' ,`RoomCount` = '3' ,`ListPrice` = '132500.00' ,`Status` = 'Active' ,`StreetName` = 'W Milam' ,`StreetNumber` = '1007' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Call soon and ask about Builder\'s current incentive***\r\n This one Story Plan with 3 bedrooms, 1 bath, one-story home is energy efficient, with an open Concept Kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting, and vinyl plank flooring in the living room, dining, kitchen, and baths. Moen fixtures in a timeless chrome finish are placed throughout the home. Lush carpeting in the bedrooms. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows!\r\nReady for move-in. No HOA!\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1607' ,`Area` = '55' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CLINE BLOCK 2 LOT 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cline' ,`TaxAmount` = '1748' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386034' WHERE `Matrix_Unique_ID` = '212982758' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:25:24.833' ,`MLSNumber` = '51394514' ,`ListAgentFullName` = 'Lyssa Lechuga' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.970958' ,`Longitude` = '-95.976852' ,`PhotoCount` = '17' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '139999.00' ,`Status` = 'Active' ,`StreetName` = 'Moore Avenue' ,`StreetNumber` = '3212' ,`StreetSuffix` = 'Avenue' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Call soon and ask about Builder\'s current incentive***\r\nNew construction ready for move-in immediately - This one-story plan with 3 bedrooms, 2 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with espresso cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty' ,`Acres` = '0.1607' ,`Area` = '54' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 7' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton-Corbett' ,`TaxAmount` = '1748' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664386034' WHERE `Matrix_Unique_ID` = '212986583' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T06:34:38.937' ,`MLSNumber` = '29159407' ,`ListAgentFullName` = 'George Chiamos' ,`ListOfficeName` = 'Royce Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081543' ,`Longitude` = '-95.517867' ,`PhotoCount` = '21' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Colter Stone' ,`StreetNumber` = '21703' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home sits on a cul-de-sac in the highly sought after Northcrest Village subdivision. It boasts an oversized backyard for uses limited only by your imagination. A big feature of this home is its large kitchen with lots of cabinet space and an island that comfortably seats 4. The pantry is a huge 11‘x 6’ storage area for dry goods and \r\n much more. \r\nThe formal dining room is currently utilized as a media room with its own screen. One of the secondary bedrooms has additional storage areas. Additionally, there is extra space in the rear of the garage for many creative uses. Secure your Scheduled your showing soon to make it yours.' ,`Acres` = '0.2062' ,`Area` = '14' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 NORTHCREST VILLAGE SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8983' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '520' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FOX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northcrest Village Sec 01' ,`TaxAmount` = '6290' ,`TaxRate` = '2.644' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386034' WHERE `Matrix_Unique_ID` = '212993679' --> 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','213001637','1664386035','213001637','2022-09-28T07:55:57.703','35898969','Alex Westbrook-McCollum','Swede\'s Real Estate LLC','','','29.451772','-94.633113','29','77650','7','1190000.00','Active','Redfish','1822','Lane','Crystal Beach','2','0','5','2040','Single-Family','Escape to paradise and watch the waves from this beautiful beachfront home! Located in the heart of Crystal Beach with absolutely no obstructed views, this 5 bedroom, 2 bathroom home is well suited for year round entertaining. Features include 22kw whole house Generac Generator installed and serviced by generator super center; 500 gallon buried propane tank; Built in Bunkbeds (sleeps 14 comfortably); Aqua Current Vetrazzo countertops; Tesla charger and storage shelf in garage; Breezesta Outdoor Furniture; Built in whole house dehumidifier; Cargo lift that reaches both floors; White vinyl ply gem fence that covers yard and under home; No carpet; Recently replaced 2 AC units and more! BUYOUT LOT on East side of property. This home has never been a rental, but would do great. Book your private tour to see this fabulous tropical hideaway!!','0.1682','33','','','Electric Dryer Connections','','Sellers Disclosure','1','','','Crystal Beach','Central Electric','0','ABST 179 J SHAW SUR LOTS 9 & 21 BLK 3 BLALOCK SUB','Water View,Waterfront','7328','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Request Online Appointment','Appraisal District','2','Other Style','Blalock','9456','1.6103','Public Water,Septic Tank','2012','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','213013576','1664386035','213013576','2022-09-28T07:46:55.097','80387282','Kathryn Montalbano','Neptune Properties','','','29.284106','-94.804404','11','77550','4','245000.00','Active','Avenue R','3705','','Galveston','1','0','2','1008','Single-Family','Location, curb appeal and great bones make this ready to be renovated classic Galveston bungalow a find! Situated on a full lot, Zone X (no flood insurance required) and a short walk to one of the best island beach areas and restaurants such as Gaido’s, Joe’s Crab Shack, and Brick House Tavern. Just down the street on the corner is Galveston College and a new $31 million Health Science Education Center with a nursing program with completion in 2023. This bungalow features an amazing full front porch, original hardwood floors ready for refinishing, 10 foot ceilings, wood trim, and is ready for your design and remodel dreams to make it a great home, vacation rental, or weekend getaway. Home is priced and sold AS-IS, no repairs.','','33','','','','','No Disclosures,Other Disclosures,Sellers Disclosure','','','','East End','No Heating','0','ABST 628 M B MENARD SUR LOT 6 NE BLK 135 GALVESTON OUTLOTS','Subdivision Lot','5568','Appraisal District','','','0','','1','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Craftsman','Galveston Outlots','3687','2.0662','Public Sewer,Public Water','1960','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:50:21.000' ,`MLSNumber` = '87073241' ,`ListAgentFullName` = 'Pam Holmes' ,`ListOfficeName` = 'Texas Premier Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.793303' ,`Longitude` = '-95.064200' ,`PhotoCount` = '0' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Ridge' ,`StreetNumber` = '536' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Forest Hills Charmer! This 1,750SF \"A\" Style home sits on 8 lots (2.031 acres) and offers 3 bed/2 bath, balcony overlooking oversized liviing room and SUNroom. Home fronts 3 roads in a WATERfront Community. The back porch has been enclosed to make a wonderful sunroom to enjoy your coffee while staying cool and mosquito free. Enjoy your evenings on the covered porch enjoying a sunset chardonnay with old friends or your days in a hammock under the mature shade trees with a great book. There\'s a 2 car-attached carport to keep you dry on those rainy days. 2-door detached garage has a small water heater to wash up after spending hours in your work space. The acreage gives plenty of room for \"Country at the Lake Gatherings!\" Own your private Slice of Heaven- Call today for your private tour. Pics coming soon' ,`Acres` = '2.0312' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FOREST HILLS SECTION 3 LOT 477 THRU 484' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '88481' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Forest Hills #3' ,`TaxAmount` = '3146' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386035' WHERE `Matrix_Unique_ID` = '213014752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:29:25.227' ,`MLSNumber` = '46450645' ,`ListAgentFullName` = 'Haider Alazzawi' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876100' ,`Longitude` = '-95.317100' ,`PhotoCount` = '23' ,`PostalCode` = '77093' ,`RoomCount` = '4' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Hill' ,`StreetNumber` = '4906' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2222' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful House built in 2006. 4 beds 2 bath. Never flooded. Recently painted inside and outside. Easy access to Hwy59 and the downtown area.' ,`Acres` = '0.1354' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 99 DARDEN PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '5900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ESCAMILLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'HAMBRICK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Darden Place' ,`TaxAmount` = '3316' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386035' WHERE `Matrix_Unique_ID` = '213029632' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-28T07:32:45.280' ,`MLSNumber` = '35878274' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827559' ,`Longitude` = '-95.539941' ,`PhotoCount` = '37' ,`PostalCode` = '77080' ,`RoomCount` = '4' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Cache' ,`StreetNumber` = '3102' ,`StreetSuffix` = 'Crossing' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2164' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Gorgeous 2164 Sq Ft, 3 bedroom, 2 1/2 bathroom home in a gated community is ready for its new owner(s)! Stunning interior has tons to offer. Upon entry, you are greeted by soft neutral tones, tile flooring, and beautiful open concept main area! Living room features electric fireplace inset with marble tile accent from floor to ceiling. Spacious island kitchen boasts dark wood cabinets with contrasting light island, stainless steel appliances, 5 burner gas cooktop, and modern tile backsplash! Upstairs offers a spacious game room, primary bedroom, utility room, and 2 large secondary bedrooms. Luxurious primary retreat features dark tray ceiling with contemporary light fixture, large windows, decorative accent wall, ensuite bathroom, and walk in closet! Home is located close to tons of shopping, dining and entertainment choices!' ,`Acres` = '0.0617' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3 PINECREST SEC 2 AMEND' ,`LotDesciption` = 'Corner' ,`LotSize` = '2687' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pinecrest Sec 2' ,`TaxAmount` = '11106' ,`TaxRate` = '3.1915' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664386035' WHERE `Matrix_Unique_ID` = '213031341' --> 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','213034968','1664386035','213034968','2022-09-28T07:28:21.253','12146098','Feras Rachid','Opendoor Brokerage, LLC','','','30.021598','-95.546281','35','77379','7','560000.00','Active','Pine Thistle','8306','Lane','Spring','5','1','7','4860','Single-Family','This Spring two-story home offers a patio, granite countertops, and a three-car garage.','0.3639','13','','','','','Sellers Disclosure','','','2','Champions Area','Central Gas','1','TRS 22 & 23A BLK 44 MEMORIAL NORTHWEST SEC 15','Subdivision Lot','15850','Appraisal District','','693','0','','3','','1','In Ground','','','','Other','32 - Klein','THEISS ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','DOERRE INTERMEDIATE SCHOOL','Appointment Required,No Supra Keybox','Seller','2','Traditional','Memorial Northwest Sec 15','9818','2.3213','Water District','1984','Seller'); --> 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','213041627','1664386035','213041627','2022-09-28T07:13:20.423','48239514','Pamela Rose','RE/MAX Lake Livingston','','','30.522122','-94.848478','27','77351','5','152000.00','Active','Pecan','209','Cove','Livingston','1','0','2','1300','Single-Family','So QUIET and RELAXING. Enjoy the pleasure of peacefulness in this country lake community conveniently located just 1 1/2 hours north of Houston. Beautiful lake front property with a deck over the lake, gazebo, nice trees and plenty of room to store RV, boat, golf cart, etc. Generously sized carport. Great fishing here. Trinity River borders neighborhood. SHORT-TERM RENTALS (i.e., AirBNB) ARE ALLOWED. House being SOLD AS-IS. House needs some repairs but is certainly livable as-is (see pictures). Recently installed central air & heat. Stained concrete floors, wood-burning fireplace, cute kitchen and has a utility room. Extra Room is being used as a bedroom. All measurements are approximate.','0.3701','44','','','','','Sellers Disclosure','','Wood Burning Fireplace','1','Livingston Area','Central Electric','1','TAYLOR LAKE ESTATE SECTION 6 LOT 7 & 8','Waterfront','16121','Appraisal District','','250','0','','0','','0','','','','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front','Seller','1','Traditional','Taylor Lake Estate Sec 6','2487','1.8745','Septic Tank','1975','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','213041697','1664386035','213041697','2022-09-28T06:24:13.070','19131279','Polly Bowman','JPAR - The Sears Group','','','29.462537','-95.064189','12','77539','8','236500.00','Active','Ash','3216','Drive','Dickinson','2','0','5','2667','Single-Family','Welcome to 3216 Ash Dr! This location is in the highly sought after Bayou Estates. This beautiful home is in a great location with easy access to Gulf Freeway which is makes the commute to Galveston or Houston a breeze. This 5/2/2 has a very spacious family room with large windows to enjoy the natural sunlight and the holidays sitting next to the fireplace with built in bookshelves. The oversized Master bedroom has a wide entry way for you to appreciate that opens up to a large sunroom. This home is being sold AS-IS. Great selection for your first home or investment property. Very little TLC needed.','0.5702','33','','','','','No Disclosures','1','','0','Dickinson','Central Electric','0','ABST 19 PERRY & AUSTIN SUR LOT 4 BAYOU ESTATES','Other','24840','Appraisal District','','','0','','2','','0','','','','','Wood Shingle','17 - Dickinson','CALDER ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Bayou Estates','5245','2.5214','Public Sewer,Public Water','1955','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','213041708','1664386035','213041708','2022-09-28T07:15:32.413','14164853','Victor Chelf','Coldwell Banker Realty, Cy-Fair Office','','','30.009637','-95.292589','45','77338','12','285000.00','Active','Orchard Ridge','8703','Lane','Humble','2','1','4','2308','Single-Family','This beautiful 2 story home sits on a corner lot and has been nicely updated. The roof was replaced in November 2019, and the A/C was replaced in June 2020. Carpet was just replaced. The kitchen has granite countertops and updated stainless steel appliances, including the gas stove, microwave oven and dishwasher. The primary bedroom ensuite is downstairs. Upstairs has the other three bedrooms upstairs, a large game room and the secondary bathroom. All bedrooms have ceiling fans and walk in closets. Wood deck in backyard.','0.1562','12','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Owner/Agent,Sellers Disclosure','1','','0','Humble Area West','Central Gas','1','LT 61 BLK 4 DEERBROOK ESTATES SEC 1 AMEND','Corner,Subdivision Lot','6806','Appraisal District','','350','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','1 - Aldine','JONES ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Deerbrook Estates','5871','2.7433','Water District','2005','Appraisal District'); --> New record created successfully