Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:26:39.300' ,`MLSNumber` = '48491370' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.621894' ,`Longitude` = '-95.380368' ,`PhotoCount` = '21' ,`PostalCode` = '77047' ,`RoomCount` = '7' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Skyview Knoll' ,`StreetNumber` = '2734' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1691' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 2 SKY VIEW PARK SEC 6' ,`LotDesciption` = 'Other' ,`LotSize` = '7368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Skyview Park Sec 6' ,`TaxAmount` = '7093' ,`TaxRate` = '2.9307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289173' WHERE `Matrix_Unique_ID` = '208277713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:25:59.807' ,`MLSNumber` = '54455232' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.612174' ,`Longitude` = '-95.305012' ,`PhotoCount` = '16' ,`PostalCode` = '77048' ,`RoomCount` = '6' ,`ListPrice` = '280690.00' ,`Status` = 'Active' ,`StreetName` = 'Wenlock' ,`StreetNumber` = '6440' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new 2 story 4 bedrooms and 2.5 baths. Open family room to Kitchen which includes 42\" cabinets, Granite Countertops, under mount sink and stainless steel appliances. Master bathroom has separate shower and tub plus dual sinks. Ceiling fans in master bedroom and family room. Garage door opener and covered rear patio. Photos are representative! MOVE IN READY.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 1 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Meadow Place' ,`TaxAmount` = '' ,`TaxRate` = '3.1' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667289173' WHERE `Matrix_Unique_ID` = '209850837' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:15:33.053' ,`MLSNumber` = '26482724' ,`ListAgentFullName` = 'Dorothy Watts' ,`ListOfficeName` = 'Martindale Real EstateInvestments' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.779962' ,`Longitude` = '-94.425484' ,`PhotoCount` = '42' ,`PostalCode` = '75979' ,`RoomCount` = '10' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Temple Street' ,`StreetNumber` = '517' ,`StreetSuffix` = '' ,`City` = 'Woodville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful property sits on the corner and has a very large backyard with a gorgeous oak tree. It is fenced and the backyard has plenty of room for playing or for your animals. This home has been remodeled and has a nice big den and also living room with built in shelves and cabinets. The kitchen has a large island for entertaining and the dining area is also spacious. Its an open concept home. The den is a very large room so it can be used for extra living or a gameroom whichever you choose. It has a 2 car covered carport but the driveway can hold extra cars. It has a large gate in the back in case you need to store your boat or atv or motorhome.' ,`Acres` = '0.742' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0657 J. Wheat Block 52, Tract B Acres .742' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '253 - Woodville' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'n/a' ,`TaxAmount` = '3330' ,`TaxRate` = '2.3293' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289173' WHERE `Matrix_Unique_ID` = '209903009' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:28:16.430' ,`MLSNumber` = '27375012' ,`ListAgentFullName` = 'Kay Robbins' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766420' ,`Longitude` = '-95.894486' ,`PhotoCount` = '46' ,`PostalCode` = '77423' ,`RoomCount` = '11' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Norhill Heights' ,`StreetNumber` = '9973' ,`StreetSuffix` = 'Lane' ,`City` = 'Brookshire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3123' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional Westin home decked w/over the top upgrades and its outdoor kitchen & pool make this a prized purchase! Nestled on cul-de-sac street w/easy access to 1-10 West Katy in sought after Willow Creek Farms & zoned to popular KISD schools. Captivating Stone & brick elevation accented w/uplighting yard,lush landscaping,sprinkler & mesquito system. Striking 2-story entry features rotunda & spiraling iron staircase with hardwood stairs w/travertine,custom rod iron covers lighting & windows in the 2-story family room. French doors opens to front study, adjacent dining, grand-size island kitchen opens to the family room. Primary bedroom downstairs w/ensuite bathroom overlook sparkling pool & new landscaping. Upstairs landing you will have gameroom opening to the media room, plus additional three bedrooms, 2 bathrooms convenient to all rooms.' ,`Acres` = '0.1377' ,`Area` = '26' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S976201 WILLOW CREEK FARMS 2 SECTION 1 BLK 1 LOT 16 ACRES .1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '598' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Creek Farms' ,`TaxAmount` = '10504' ,`TaxRate` = '3.1705' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289174' WHERE `Matrix_Unique_ID` = '210328476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:35:13.007' ,`MLSNumber` = '13570908' ,`ListAgentFullName` = 'Fatema Moqbel' ,`ListOfficeName` = 'Century 21 Olympian Galleria' ,`SellingAgentFullName` = 'Monica Avila' ,`SellingOfficeName` = 'RE/MAX Cinco Ranch' ,`Latitude` = '29.701997' ,`Longitude` = '-95.763127' ,`PhotoCount` = '40' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '660000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Grand Prominence' ,`StreetNumber` = '6327' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS 2 story home 6 bedrooms & 4.5 bathrooms built in 2018. Located on large CUL-DE-SAC in private GATED community inside the Grand Parkway. Katy ISD & Seven Lakes High School. Home has covered patio, fireplace, game room & media room. Open island kitchen with extra cabinets & 2 bedrooms down. Primary bedroom is located on 1st floor with Master Bath that has deck mounted tub, mud set shower & dual sinks. Second bedroom downstairs has its own full bathroom. Great for your IN LAWS or GUESTS. Exterior features a STUNNING brick, stone, & stucco castle elevation. UPGRADED countertops & lush carpet. Sprinkler system. No REAR neighbors. Back yard is LARGE enough to build your DREAM Swimming pool. Owners added CLOSET in the primary bedroom & another HUGE one in game room upstairs. Buyers and their agents need to verify everything & measurement.' ,`Acres` = '0.2319' ,`Area` = '36' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND Ridge CROSSING, BLOCK 1, LOT 47' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10128' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Grand Ridge Crossing' ,`TaxAmount` = '13067' ,`TaxRate` = '2.8712' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667289174' WHERE `Matrix_Unique_ID` = '210799652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:04:49.587' ,`MLSNumber` = '44031046' ,`ListAgentFullName` = 'Kenya Fanus' ,`ListOfficeName` = 'Elite 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783658' ,`Longitude` = '-95.041687' ,`PhotoCount` = '14' ,`PostalCode` = '77520' ,`RoomCount` = '8' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Crestway' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your home awaits your personal touches to make it complete! This beautiful 4/5 bedroom and 3/1 baths home has it all within its 3,515sq ft. Natural light pours into the open concept living area creating a very bright & enjoyable space to share with the family! Enjoy preparing meals in this impressive gourmet kitchen equipped with ample cabinets and generous counter space. The primary bathroom features a separate tub and shower, dual sinks, and a walk-in closetThe oversized backyard has it\'s own own basketball court and yet still enough room for that pool, which is perfect for entertaining. This one story home truly has everything that you have been dreaming of. Selling AS-IS, no repairs. Submit offer accordingly. Seller is motivated and will review all offers.' ,`Acres` = '0.4385' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 58 LAKEWOOD SEC M' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Sec M' ,`TaxAmount` = '8666' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289174' WHERE `Matrix_Unique_ID` = '211048041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:29:49.510' ,`MLSNumber` = '57943921' ,`ListAgentFullName` = 'Paul Olascoaga' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = 'Faisal Darugar' ,`SellingOfficeName` = 'Central Metro Realty' ,`Latitude` = '30.088625' ,`Longitude` = '-95.228258' ,`PhotoCount` = '6' ,`PostalCode` = '77365' ,`RoomCount` = '3' ,`ListPrice` = '280000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Martin' ,`StreetNumber` = '22447' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Corner Lot! Two adjacent lots being sold together to make up 2.28 Acres. 2 Mobile homes currently on the property with city sewer and water. The mobile home at the corner is currently being rented out on a month to month term. The other mobile home, the white mobile home, is heavily damaged and can be removed if requested.' ,`Acres` = '2.28' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S926002 - TIMBERLANE ACRES 02, BLOCK 1, LOT 9-A, SERIAL # 03' ,`LotDesciption` = 'Corner' ,`LotSize` = '99315' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberlane Acres 02' ,`TaxAmount` = '1003' ,`TaxRate` = '2.5431' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289174' WHERE `Matrix_Unique_ID` = '211421341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:13:34.230' ,`MLSNumber` = '52382762' ,`ListAgentFullName` = 'Mariela Knapp' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194373' ,`Longitude` = '-95.511219' ,`PhotoCount` = '22' ,`PostalCode` = '77381' ,`RoomCount` = '10' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Flagstone' ,`StreetNumber` = '12' ,`StreetSuffix` = 'Path' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3367' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning house for sale, excellent update house is rare to find. 4 or 5 bedrooms and four and a half bathrooms. Three bedrooms upstairs and principal rooms downstairs. Lovely casita outside with full bathroom, close to the garage could be for the in-laws or the teenagers. This house has so many great spacious like a big backyard, the extra room upstairs you can use for office or texas baseman. The sellers need 15 days of leaseback. Great location and great schools. No carpet in the house. The AC update 2018 for both units. The kitchen was updated with appliances. Please see the list on MLS' ,`Acres` = '0.26' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S972242 - WDLNDS VIL COCHRANS CR 42, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'POWELL ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr' ,`TaxAmount` = '10864' ,`TaxRate` = '2.1269' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289174' WHERE `Matrix_Unique_ID` = '211503073' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:38:25.540' ,`MLSNumber` = '20754469' ,`ListAgentFullName` = 'Darius Franklin' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = 'Maryann Okoronkwo' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.080171' ,`Longitude` = '-95.522640' ,`PhotoCount` = '23' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '338087.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Seminole Lodge' ,`StreetNumber` = '6706' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In a location second to none in terms of convenience and availability of stores/restaurants, this is one of the biggest floor plans in the community. The \"Spring\" by Centex homes, features 5 large size bedrooms (one downstairs, not the master) and 3 full bathrooms. Brand new gas range, brand new carpet upstairs, (no carpet downstairs), new paint, new wood floor in the downstairs bedroom/office. Brand new water heater, brand new smoke detectors, belt drive garage opener. Take a look at the pictures...' ,`Acres` = '0.1294' ,`Area` = '14' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 2 SPRING TERRACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5637' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MUELLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Terrace' ,`TaxAmount` = '7175' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667289175' WHERE `Matrix_Unique_ID` = '211840183' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:43:48.990' ,`MLSNumber` = '3426811' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401162' ,`Longitude` = '-95.056193' ,`PhotoCount` = '16' ,`PostalCode` = '77568' ,`RoomCount` = '8' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Bonita Island' ,`StreetNumber` = '13505' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1982' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL BRAND NEW COLINA HOME- LARGE 1STORY WITH 4 BEDROOMS, 3 FULL BATHS , WITH STUDY, INCLUDES 2\' FAUX WOOD BLINDS, BUILT IN TAEXX PEST CONTROL, BACK COVERED PATIO, GRANITE KITCHEN, 42\" WHITE CABINETS WITH CROWN MOLDING, 9\" SINGLE BOWL KITCHEN SINK, STAINLESS STEEL 5 BURNER GAS APPLIANCES, VINYL PLANK FLOORING EVERYWHERE EXCEPT & BEDROOMS, OPEN HOME PLAN, BRICK ELEVATION, FRONT GUTTERS, LENNOX 16 SEER A/C, 4TH SIDE BRICK AND MUCH MORE! These are photo\'s of the home plan not of the actual property. MOVE IN READY!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 1 Sec 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667289175' WHERE `Matrix_Unique_ID` = '212099111' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:29:10.360' ,`MLSNumber` = '9015806' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401162' ,`Longitude` = '-95.056193' ,`PhotoCount` = '24' ,`PostalCode` = '77568' ,`RoomCount` = '12' ,`ListPrice` = '334990.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Palms' ,`StreetNumber` = '2617' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2201' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL BRAND NEW COLINA HOME- LARGE 2 STORY WITH 3 BEDROOMS, 2.5 BATHS , WITH FORMAL DINING ROOM, Study, INCLUDES 2\' FAUX WOOD BLINDS, BUILT IN TAEXX PEST CONTROL, BACK COVERED PATIO, GRANITE KITCHEN, 42\" CABINETS WITH CROWN MOLDING, 9\" SINGLE BOWL KITCHEN SINK, DOUBLE SINKS IN MASTER BATH, STAINLESS STEEL 5 BURNER GAS APPLIANCES, VINYL PLANK FLOORING EVERYWHERE EXCEPT & BEDROOMS, DINING ROOM AND STAIRS AND LOFT/GAMEROOM ( 2) OPEN HOME PLAN, BRICK ELEVATION, FRONT GUTTERS, LENNOX 16 SEER A/C , BRICK/STONE ELEVATION! THIS HOME IS MOVE IN READY!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 2 sec 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667289175' WHERE `Matrix_Unique_ID` = '212099414' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:04:30.570' ,`MLSNumber` = '36173744' ,`ListAgentFullName` = 'Kathryn Robinson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Michael Brombacher' ,`SellingOfficeName` = 'Brombacher & Co.' ,`Latitude` = '29.810440' ,`Longitude` = '-95.397182' ,`PhotoCount` = '46' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '670000.00' ,`Status` = 'Option Pending' ,`StreetName` = '26th' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'French Quarter patio home by Distinctive Living. This home has ornate iron double gallery\r\nporches done to accurate Creole design on a mature tree lined street. Antique hardwood flooring\r\nand Italian Marble throughout. Commercial-grade SS appliances. Kitchen has floor to 10 ceiling\r\ncabinetry open to large den. New Orleans imported Antique butcher block island top. The master\r\nsuite has coffered ceilings that includes two closets. Ornate wainscoting in the entrance of\r\nthe house. Beautiful builtins in the formal dining room & living room. Easily maintained pet\r\nturf in the backyard. Newly repainted porches, front exterior, and several of the bedrooms. Wood floors are newly refinished on the first floor as well!\r\nWalking distance to Johnny Goldbrick, Tenfold coffee, F45 Greater Heights, Relic general store,\r\nAngelas oven and so much more!' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = 'Distinctive Living' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 36 SUNSET HEIGHTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French,Victorian' ,`Subdivision` = 'Sunset Heights Add' ,`TaxAmount` = '12267' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289175' WHERE `Matrix_Unique_ID` = '212238915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:37:59.687' ,`MLSNumber` = '15251300' ,`ListAgentFullName` = 'Sharon Murillo' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.969663' ,`Longitude` = '-95.568970' ,`PhotoCount` = '30' ,`PostalCode` = '77070' ,`RoomCount` = '9' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Dryden Mills' ,`StreetNumber` = '13626' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GO AHEAD AND FALL IN LOVE... This time you can afford it! This 4 bedroom, 2 bathroom home will give you 1,616 sq ft of generous space to move without losing that quaint and cozy atmosphere around this house. The focal point of the living room is the fireplace adding an element of coziness. Designed to suit all occasions from entertaining guests to relaxing after a day at work. A remarkable opportunity awaits owner-occupiers and investors alike. Act quickly as you will not get a second chance at this price! Don\'t miss out on this fantastic opportunity, contact us today to schedule your private showing.' ,`Acres` = '0.1152' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 3 FAIRLANE VILLAGE SEC 1' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5017' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '552' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HANCOCK ELEMENTARY SCHOOL (CY-FAIR)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairlane Village Sec 01' ,`TaxAmount` = '4776' ,`TaxRate` = '2.5937' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289175' WHERE `Matrix_Unique_ID` = '212330150' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:35:09.650' ,`MLSNumber` = '22227323' ,`ListAgentFullName` = 'Margie Poole' ,`ListOfficeName` = 'Poole Realty Group' ,`SellingAgentFullName` = 'Michael Burdette' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.059866' ,`Longitude` = '-94.909353' ,`PhotoCount` = '36' ,`PostalCode` = '77535' ,`RoomCount` = '8' ,`ListPrice` = '289900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 661' ,`StreetNumber` = '431' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quality Surrounds You In This Stunning One-Story Home On .60 Of An Acre. The Second You Walk Through The Door You\'ll Fall In Love! This Home Was Completely Remodeled With No Expense Spared! Beautiful Light And Airey Color Scheme Throughout Has The Perfect Combinations Of Neutrals To Coordinate With Any Decor. The Family Room Is Super Spacious, Has A Charming Fireplace & Plenty Of Natural Light. The Galley Style Kitchen Features An Abundance Of Cabinets & Deep Drawers For Pots & Pans, Gorgeous Granite Countertops, Stainless Appliances, Breakfast Bar & A Dry Bar. The Primary Bedroom Has A Closet That Most Only Dream About! So Much Space And Built-Ins! The Primary Bath Has Marble Counters And A Self Cleaning Toilet! The Back Porch Is Over 45 Ft In Length And The Back Yard Is Completely Fenced, Has Double Wide Gates And Is Enhanced With Rod Iron Accents. There Is A Bonus Room Behind The Carport That\'s Perfect For Your Home Gym, Office Or Playroom! Storage Building In The Back Will Stay.' ,`Acres` = '0.609' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'FRIEDMAN 38 AC, LOT 1 TR 5, ACRES 0.609' ,`LotDesciption` = 'Cleared' ,`LotSize` = '26528' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Friedman 38 Ac' ,`TaxAmount` = '4248' ,`TaxRate` = '2.4832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289176' WHERE `Matrix_Unique_ID` = '212856870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:09:39.873' ,`MLSNumber` = '93442058' ,`ListAgentFullName` = 'Billy Martinez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763459' ,`Longitude` = '-95.268894' ,`PhotoCount` = '22' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '162900.00' ,`Status` = 'Active' ,`StreetName` = 'Pattibob' ,`StreetNumber` = '8723' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful well maintained property in the sought after neighborhood of Pleasantville!! Property has had many recent upgrades, including, new roof and a fresh coat of paint . Property is tenant occupied by long time tenant.' ,`Acres` = '0.1277' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 317 BLK 12 PLEASANTVILLE SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PLEASANTVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pleasantville Sec 07' ,`TaxAmount` = '1971' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289176' WHERE `Matrix_Unique_ID` = '212890853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:12:35.980' ,`MLSNumber` = '11649126' ,`ListAgentFullName` = 'Lindsay Sterling' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.994235' ,`Longitude` = '-95.143533' ,`PhotoCount` = '47' ,`PostalCode` = '77346' ,`RoomCount` = '11' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Mile Run' ,`StreetNumber` = '8624' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3897' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMPECCABLY MAINTAINED and EXTENSIVELY UPGRADED and IMPROVED, this well-kept one owner home will not disappoint! They don\'t build them like this anymore. With storage galore and oversized bedrooms and large walk-in closets, the layout is equally spacious and functional. There are linen closets in each bathroom and storage closets throughout. The fully enclosed cedar patio with ceiling fans and strung lights is the highlight of this home, along with the pavered extended patio complete with custom landscaping and lighting for enchanted evenings under the stars. Inside, the kitchen has been upgraded with custom, solid wood cabinetry, pull out drawers and a mobile island any chef will appreciate. All bathrooms have been remodeled. This home is incredibly ENERGY EFFICIENT. See attached sheet for extensive list of upgrades including NEW ROOF 2018, NEW IONIC HVAC SYSTEM 2020, ALL NEW RENEWAL by ANDERSON WINDOWS 2018. NEVER FLOODED! Schedule your tour today!' ,`Acres` = '0.1928' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 17 OLYMPIC VILLAGE WALDEN ON LAKE HOUSTON PH 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden On Lake Houston Ph 02' ,`TaxAmount` = '7808' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289176' WHERE `Matrix_Unique_ID` = '212993715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:01:55.243' ,`MLSNumber` = '84520520' ,`ListAgentFullName` = 'Blanca Llanez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015129' ,`Longitude` = '-95.320974' ,`PhotoCount` = '23' ,`PostalCode` = '77338' ,`RoomCount` = '5' ,`ListPrice` = '215900.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Glen' ,`StreetNumber` = '20307' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER. GORGEOUS, UPDATED KITCHEN AND AMAZING HALL BATHROOM. Enjoy your holidays in your beautiful 3/2/2 one-story with open floor plan and huge back yard and deck. Great for entertaining. Preparing meals in your beautiful kitchen with granite counters, tiled backsplash, and cabinets galore will be a joy. New wine-fridge. Appliances about 3 years old. A/c unit and central heat were replaced. Other new items: Sliding patio door, kitchen sink and faucet. New Roof 2019. Primary bedroom has an additional 8x10 space for study, office, nursury, etc. There\'s also a nice private patio outside the primary bedroom. All walk-in closets in bedrooms. Measurements are approximate - please verify all measurements and information. Located in established neighborhood. Just a few blocks to the community center. Location, location, location! Convenient, close to Bush airport, shopping, freeways. Come see and make this your new home!' ,`Acres` = '0.1612' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 5 FOXWOOD SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Foxwood Sec 02' ,`TaxAmount` = '4377' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289176' WHERE `Matrix_Unique_ID` = '213213708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:49:48.140' ,`MLSNumber` = '42145051' ,`ListAgentFullName` = 'Sheryle Campbell' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738712' ,`Longitude` = '-95.571142' ,`PhotoCount` = '34' ,`PostalCode` = '77042' ,`RoomCount` = '7' ,`ListPrice` = '607000.00' ,`Status` = 'Active' ,`StreetName` = 'Wickersham' ,`StreetNumber` = '11010' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just in time for the holidays--MODERN RENOVATED home with a PRIVATE POOL in the heart of the Energy Corridor! Fall in love with the stunning interior while moving in with peace of mind with a New roof, new AC units, and PEX plumbing. Luxury Vinyl Wood Plank floors are the hottest flooring in homes today and flow continuously throughout the first and second floors with no carpet. The expansive kitchen island is appointed with CALCUTTA QUARTZ counters and opens to both the living and dining room. The gourmet kitchen is a chef\'s dream with a six-burner GAS RANGE and all STAINLESS STEEL APPLIANCES. The spacious first floor primary bedroom boasts a spa-like ensuite bathroom that has been completely renovated with a large walk-in shower and on-trend finishes. Three bedrooms and 2 bathrooms upstairs also boast on-trend finishes so you can move in without lifting a finger. The central location offers easy access to Westheimer and the Beltway so you can get around Houston with ease.' ,`Acres` = '0.2049' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 3 LAKESIDE ESTATES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8925' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '811' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Estates' ,`TaxAmount` = '7273' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289176' WHERE `Matrix_Unique_ID` = '213309340' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:51:14.817' ,`MLSNumber` = '81092641' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857525' ,`Longitude` = '-95.192800' ,`PhotoCount` = '29' ,`PostalCode` = '77044' ,`RoomCount` = '7' ,`ListPrice` = '279300.00' ,`Status` = 'Active' ,`StreetName` = 'Cardin' ,`StreetNumber` = '9511' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1615' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETION JANUARY/FEBRUARY 2023 Brand new 1 story 3-bedroom 2 bath 2 car garage. LARGE CORNER LOT OVERSIZED MASTER BEDROOM AND FAMILY ROOM LOADED WITH UPGRADES. Colina Home features Fantasy Blue granite countertops, White 42” cabinets, 9” farmhouse sink, stainless steel range, microwave, and dishwasher to include our premium 5 burner range, subway kitchen tile backsplash. 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanity, large walk-in closet, covered back patio, carpet only in bedrooms, luxury vinyl wood plank throughout. Raised panel doors, rounded sheetrock corners and archways. Pex Plumbing, Lennox 16 seer A/C. Taexx Pest Control. All this included for you. Don\'t miss out on 365day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2 Section 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667289177' WHERE `Matrix_Unique_ID` = '213405736' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:50:25.613' ,`MLSNumber` = '58477749' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857525' ,`Longitude` = '-95.192800' ,`PhotoCount` = '29' ,`PostalCode` = '77044' ,`RoomCount` = '7' ,`ListPrice` = '279500.00' ,`Status` = 'Active' ,`StreetName` = 'Lanrin Park' ,`StreetNumber` = '13207' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1615' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETION JANUARY/FEBRUARY 2023 Brand new CORNER LOT 1 story 3-bedroom 2 bath 2 car garage. LARGE CORNER LOT OVERSIZED MASTER BEDROOM AND FAMILY ROOM LOADED WITH UPGRADES. Colina Home features Fantasy Blue granite countertops, White 42” cabinets, 9” farmhouse sink ,stainless steel range, microwave, and dishwasher to include our premium 5 burner range , subway kitchen tile backsplash. 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanity, large walk-in closet, covered back patio, carpet only in bedrooms, luxury vinyl wood plank throughout. Raised panel doors, rounded sheetrock corners and archways. Pex Plumbing, Lennox 16 seer A/C. Taexx Pest Control. All this included for you. Don\'t miss out on 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 5 Section 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667289177' WHERE `Matrix_Unique_ID` = '213418086' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:49:23.307' ,`MLSNumber` = '16454483' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860818' ,`Longitude` = '-95.192393' ,`PhotoCount` = '44' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '341440.00' ,`Status` = 'Active' ,`StreetName` = 'Vuitton' ,`StreetNumber` = '13223' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COLINA HOMES estimated completion January/February. Modern floor plan features 2 Story 19\' ceiling in family room, w/ 4 Bedrooms + 2.5 baths+10\' ceilings in game-room + 10x18\' Covered back Patio! 42” Light Ash Gray Cabinets with crown molding+ Stormy Night Luxury Granite + Arabesque Mosaic-Tile Back splash + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Microwave & 5-BURNER GAS RANGE! 6x24 Porcelain Floor tile (wood look) at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite with 9\' trey ceilings, 36\" Cabinets with Double Sinks, Large soaking Garden Tub & Spacious Separate Shower! 2” Faux Wood Blinds, Ceiling Fans in All Rooms, Mahogany front door. Garage Door Opener, Tank less Water Heater, In-Wall Pest-Defense & much more! 365 DAY RATE LOCK! PICS OF SIMILAR HOME.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 3 Sec 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8580' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tidwell Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.71' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667289177' WHERE `Matrix_Unique_ID` = '213419656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:48:34.263' ,`MLSNumber` = '11628662' ,`ListAgentFullName` = 'Laura Bolieu' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.646202' ,`Longitude` = '-95.119125' ,`PhotoCount` = '45' ,`PostalCode` = '77505' ,`RoomCount` = '12' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Rainbow Bend' ,`StreetNumber` = '7715' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 4 bedroom 2.5 bath home located in sought after Village Grove East subdivision. 3 car detached garage nestled on a cul-de-sac. Primary suite downstairs w/double sinks and storage in the primary bath. Grand foyer,Open concept living w/high vaulted ceilings, formal dining oversized flex space situated on an oversized lot.in Deer Park ISD. Community pool and parks. Walking trails nearby and close to shopping, dining and Bltwy 8 for commute.' ,`Acres` = '0.281' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 VILLAGE GROVE EAST SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Grove East' ,`TaxAmount` = '8038' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289177' WHERE `Matrix_Unique_ID` = '213430271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:40:57.680' ,`MLSNumber` = '60945703' ,`ListAgentFullName` = 'Teresa Louis' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.829476' ,`Longitude` = '-95.313084' ,`PhotoCount` = '10' ,`PostalCode` = '77016' ,`RoomCount` = '5' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Shotwell' ,`StreetNumber` = '7609' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is great for first time home buyers, investors and anyone looking to buy an affordable home. THIS HOME IS PRICED TO SELL FAST.' ,`Acres` = '0.1765' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 117 BLK 7 TRIANGLE GARDENS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Triangle Gardens' ,`TaxAmount` = '1230' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289178' WHERE `Matrix_Unique_ID` = '213448960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:04:51.427' ,`MLSNumber` = '90486082' ,`ListAgentFullName` = 'Heather Johnson' ,`ListOfficeName` = 'Full Circle Texas, LLC' ,`SellingAgentFullName` = 'Isabella Rodas' ,`SellingOfficeName` = 'Realty World Metropolitan' ,`Latitude` = '29.809239' ,`Longitude` = '-94.995974' ,`PhotoCount` = '12' ,`PostalCode` = '77521' ,`RoomCount` = '3' ,`ListPrice` = '199000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Breda' ,`StreetNumber` = '7706' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story in desirable neighborhood. This 3/2/2 home boasts an open floor plan with spacious living room, beautifully updated kitchen, and great sized bedrooms. Backyard is ready for entertaining with lots of room for those kiddos and dogs to run around. Great location with close by amenities. This home is a must see and will not last long! Make your appointment to see it today!' ,`Acres` = '0.1567' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 234 BLK 7 MEADOW LAKE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Lake Sec 01' ,`TaxAmount` = '3891' ,`TaxRate` = '2.755' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289178' WHERE `Matrix_Unique_ID` = '213466448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:47:28.927' ,`MLSNumber` = '59232843' ,`ListAgentFullName` = 'Thomas Villanueva' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839569' ,`Longitude` = '-95.480853' ,`PhotoCount` = '32' ,`PostalCode` = '77092' ,`RoomCount` = '7' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Gilman Trace' ,`StreetNumber` = '6006' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All this home for under $375K! Wow!! Located just outside the loop in Pinemont Park. The home has 4 bedrooms, 2 1/2 baths and a 2 car garage. Pinemont Park has only one entrance and one ext. Quiet neighborhood w friendly neighbors. Enter this home w first floor living and hard floor run through the open floor plan living and dining. High ceilings, lots of windows and space for a large. Living area is spacious with a cathedral ceiling. Plenty of room for a sectional. Dining can easily handle a table for 6 or 8. Kitchen has gas cooking, walk in pantry and plenty of countertops. Primary suite is on 1st floor. Primary bath w double sink vanity, separate tub and shower. Large walk in closet. Living area opens to back and side yards. Great for the kids or fur babies! Upstairs landing can be play area or WFH space. Three additional bedrooms and full bath. Each bedroom has a big closet. Easy access to freeways. Active HOA. Community park down the street.' ,`Acres` = '0.1137' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 PINEMONT SQUARE SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '4951' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinemont Square Sec 02' ,`TaxAmount` = '6762' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289178' WHERE `Matrix_Unique_ID` = '213578232' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:32:29.443' ,`MLSNumber` = '66981250' ,`ListAgentFullName` = 'Joyce Tang' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.814165' ,`Longitude` = '-95.711448' ,`PhotoCount` = '36' ,`PostalCode` = '77084' ,`RoomCount` = '10' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Clevera Walk' ,`StreetNumber` = '19531' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2460' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 5 Bedrooms 3 Full Bath Home located in the quiet and desirable Lake Ridge Community. FRESH INSIDE AND OUTSIDE PAINTING, NEW SECOND FLOOR, FIRST FLOOR CHANGED FEW YEARS AGO. This all brick home is equipped with a unique floor plan offering a convenient fifth bedroom located on the 1st floor with Full Bathroom & Stand-in Shower, plus a flex room can use it as your office space! FRESH PAINTING. The 2nd story includes the Master Suite, Master Bathroom with NEW floor, 4 additional bedrooms, and 3rd full bath. , Spacious Master Walk-in Closet! The community has a Kids\' Play area and a Swimming Pool. Great KATY ISD Schools!! Minutes away from Interstate 10 and Easy access to Grand parkway. Local Commercial Shopping, Dining, Medical Facilities & Entertainment. NO FLOODING DURING HARVEY! Come and see today!' ,`Acres` = '0.1085' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 LAKE RIDGE SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '530' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RHOADS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Rdg Sec 7' ,`TaxAmount` = '5575' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289178' WHERE `Matrix_Unique_ID` = '213652622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:20:24.597' ,`MLSNumber` = '84056171' ,`ListAgentFullName` = 'Erica Alvarez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.380737' ,`Longitude` = '-95.479594' ,`PhotoCount` = '23' ,`PostalCode` = '77303' ,`RoomCount` = '5' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Rain' ,`StreetNumber` = '4914' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2675' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Thank you for your interest in Summer Wood. This is a beautiful home that’s truly been cared for by its owners. Survey attached and warrenty information will be provided upon request. \r\nHigh ceilings, granite top counters a game room with additional storage and an amazing back yard with its own private HEATED pool and beautiful landscaping including fruit bearing trees! \r\nYou won’t want to miss this gem. Room sizes are approximate and HOA information needs to be verified.' ,`Acres` = '0.1366' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S906400 - SUMMER WOOD 01, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'A.R. TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'Summer Wood' ,`TaxAmount` = '5631' ,`TaxRate` = '2.1823' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289178' WHERE `Matrix_Unique_ID` = '213829230' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:11:08.270' ,`MLSNumber` = '40236607' ,`ListAgentFullName` = 'Jeffrey Walters' ,`ListOfficeName` = 'Virginia Malone Realty' ,`SellingAgentFullName` = 'Maria Parra' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.806093' ,`Longitude` = '-94.832155' ,`PhotoCount` = '44' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '625000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'William' ,`StreetNumber` = '1607' ,`StreetSuffix` = 'Trace' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4588' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Unique Home is located in Malley Woods in BHISD. Don\'t let the façade fool you. This home is approximately 4,588sq ft of living area per CCAD and sitting on over 1/2 acre of land. The exterior is that of a nice traditional home with a circular drive. The interior sets the tone for living in a fairy tale castle. The high ceilings, marble, tile and wood floors are magnificent, but that doesn\'t compare to the woodwork throughout. Master bedroom with sitting area, do you want an office, a library, additional rooms for your own desires. Oh don\'t forget the amazing media room for hours of entertaining friends. Outdoor covered patio is amazing, overlooking a nice yard ready for a pool oasis to be installed. Must see with so many amenities I can\'t list. SELLER REQUIRES ANYONE ENTERING HOME **MUST WEAR BOOTIES PROVIDED** AT GARAGE ENTRANCE. Provide a pre-qualification letter. NO EXCEPTIONS.' ,`Acres` = '0.5768' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 MALEY WOODS #1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25126' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Maley Woods Ph 01' ,`TaxAmount` = '10702' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289179' WHERE `Matrix_Unique_ID` = '213853675' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:16:18.630' ,`MLSNumber` = '26744142' ,`ListAgentFullName` = 'Kourtney Walker' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.995107' ,`Longitude` = '-95.635640' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '9' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Kavanaugh' ,`StreetNumber` = '13514' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A lovely 4/5-bedroom home located on a large corner lot in Longwood Village with a gorgeous backyard pool. The home is located across from a park, tennis courts and neighborhood recreation facility. The formal entry welcomes you into the home. The study is located at the front of the home with a large window that looks out onto your front yard. The formal dining room is open and connected to the kitchen by a butler\'s pantry and walk-in pantry. The spacious kitchen features a large island and extensive counter space. The kitchen opens to the family room and breakfast area. The family room has an abundance of windows that allow you to enjoy views of your backyard. One wing of the home features a full bathroom and two secondary bedrooms. The second wing of the home includes the extra room with built-ins, secondary bedroom and full bathroom. The primary bedroom is privately located at the rear of the home with more views of your immaculate backyard. Don\'t miss out on this amazing home.' ,`Acres` = '0.232' ,`Area` = '10' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 LONGWOOD VILLAGE SEC 19' ,`LotDesciption` = 'Corner,In Golf Course Community' ,`LotSize` = '10106' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Longwood' ,`TaxAmount` = '9714' ,`TaxRate` = '2.4837' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667289179' WHERE `Matrix_Unique_ID` = '213872574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:08:21.493' ,`MLSNumber` = '97667524' ,`ListAgentFullName` = 'Sherry McNabb' ,`ListOfficeName` = 'Nest Ahead' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800320' ,`Longitude` = '-95.791984' ,`PhotoCount` = '41' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Lanning' ,`StreetNumber` = '24410' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2179' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home in Lakecrest, a gorgeous subdivision just minutes away from I-10 and 99 Grand Parkway! Open-flow concept with engineered flooring in the main areas and primary bedroom, tile and granite in kitchen and bathrooms, new dishwasher, high-end insulated garage door, and many more upgrades! Home has just been completely repainted. This backyard is big enough for a pool, and the front yard is oversized as well with gorgeous mature trees! Lakecrest Community has so much to offer with walking trails, playground and a community pool. Low tax rate and low HOA dues. This HOME IS A MUST SEE! Schedule your showing today.' ,`Acres` = '0.2793' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 2 LAKECREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12166' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakecrest' ,`TaxAmount` = '6186' ,`TaxRate` = '2.5733' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289179' WHERE `Matrix_Unique_ID` = '213973362' --> 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','213974016','1667289179','213974016','2022-10-31T23:28:16.617','22828622','Elizabeth Villarreal','Coldwell Banker Realty','','','29.835724','-95.465405','1','77092','4','459500.00','Active','Verdome','5005','Lane','Houston','2','0','4','1271','Single-Family','COMING SOON! Absolutely gorgeous Oak Forest mid-century mod brick cottage with many brand new updates and mechanicals including a freshly painted exterior, insulated windows and more. A rare 4 bedroom, 2 full bath plus 2 car detached garage! Never flooded; flood insurance not required per Sellers.','0.166','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Oak Forest West Area','Central Gas','0','LT 10 BLK 9 OAK FOREST SEC 16','Subdivision Lot','7232','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','SMITH ELEMENTARY SCHOOL (HOUSTON)','SCARBOROUGH HIGH SCHOOL','CLIFTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Supra Keybox,Temporarily No Showings','Appraisal District','1','Ranch','Oak Forest','6203','2.3307','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:44:00.547' ,`MLSNumber` = '29992206' ,`ListAgentFullName` = 'Stacy Newton' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.094634' ,`Longitude` = '-95.423893' ,`PhotoCount` = '50' ,`PostalCode` = '77373' ,`RoomCount` = '11' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Hausworth' ,`StreetNumber` = '22902' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OFFER ACCEPTED PENDING SIGNATURES\r\nLooking for your own private oasis look no further. This immaculate home sits on an oversized lot at the end of a cul-de-sac with a gated driveway for added privacy. Featuring a pebble tech pool and spa (there is a custom pool safety net that will stay), fire pit and an outdoor kitchen space with surround sound. The 3 car garage offers an unfinished bonus room upstairs that is accessible through the garage. Great for storage or can be converted to an apartment. The interior of the home has been completely repainted, new flooring throughout the entire downstairs and the primary bathroom has been updated as well. The home features five full bedrooms and three full baths with a half bathroom downstairs. Upstairs you have not one but two additional living areas. Full home backup generator included. You will fall in love with this property!!' ,`Acres` = '0.2679' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 1 VILLAGES OF NORTHGATE CROSSING SEC 7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11668' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '655' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Northgate Crossing 07' ,`TaxAmount` = '8455' ,`TaxRate` = '3.1142' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289179' WHERE `Matrix_Unique_ID` = '214006757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:49:00.433' ,`MLSNumber` = '56305156' ,`ListAgentFullName` = 'Susan Garczynski' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.039776' ,`Longitude` = '-95.462975' ,`PhotoCount` = '50' ,`PostalCode` = '77566' ,`RoomCount` = '9' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum' ,`StreetNumber` = '54' ,`StreetSuffix` = 'Court' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 Bedroom Home in the Heart of Lake Jackson! Recently updated with gorgeous flooring downstairs and an updated half bathroom too! Multiple Living Areas plus a Large Family Room that is open to the Kitchen and Breakfast Room. Kitchen has granite counters and an abundance of cabinet and counter space. The Primary Suite is a Must See! The Bedroom is Large and the Bathroom has double sinks plus a separate shower and large jetted tub! This Fabulous Home is located on a Huge Lot on a cul-de-sac street. It has an oversized Screened in Porch in the backyard with mature trees. Another exciting plus about this property is the extended driveway that allows for multiple vehicles to be parked. Contact your Agent today for a showing! This Beauty will sell fast!' ,`Acres` = '0.2123' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PLANTATION VILLAGE SEC 9 (LAKE JACKSON), BLOCK 3, LOT 40' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9248' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Village' ,`TaxAmount` = '6224' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289179' WHERE `Matrix_Unique_ID` = '214007037' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:23:27.593' ,`MLSNumber` = '17829492' ,`ListAgentFullName` = 'Kitako Kureyama' ,`ListOfficeName` = 'Forever Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480025' ,`Longitude` = '-95.212940' ,`PhotoCount` = '11' ,`PostalCode` = '77546' ,`RoomCount` = '3' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Mission Circle' ,`StreetNumber` = '2514' ,`StreetSuffix` = 'Circle' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a stunner and deal! This beautiful, fully updated property is in a quiet neighborhood, highly rated Friendswood School District. The fourth bedroom has been converted into huge master closet with huge storage. It has a pool with beautiful landscaping and views. Recent updates include: high grade laminate floor through-out except wet areas, no carpet in this property; granite counter-tops throughout; dual sinks and separate bath/ shower in masters; high-end SS appliances; new water-heater, and more. It has Control 4 (most advanced security/remote control solution) installed in the Living room, kitchen, master bedroom, master bath, and the backyard. Smart locks and a Ring doorbell/camera. A ton of cool updates...This is a must see and wont last long. Control 4 and washer and dryer may stay...' ,`Acres` = '0.18' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 625 B S & F SUR LOT 16 BLK 7 CARMEL VILLAGE SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Carmel Village Ph I' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667289180' WHERE `Matrix_Unique_ID` = '214018398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:23:22.697' ,`MLSNumber` = '51300871' ,`ListAgentFullName` = 'Ruth Rodriguez' ,`ListOfficeName` = 'Metro Plus Realty PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772832' ,`Longitude` = '-94.949887' ,`PhotoCount` = '38' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '229990.00' ,`Status` = 'Active' ,`StreetName` = 'El Rancho' ,`StreetNumber` = '1408' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home is on a large lot in a desirable neighborhood. From the open-bar area in the kitchen to the high ceiling in the living room space to the converted garage that can either be use for a gym, party room the space is endless. Home has a connection to a 50amp generator to generate the home for an emergency. Large covered patio with a huge backyard for family and friends to enjoy. Recent updates include HVAC/ COVERED PATIO/ STORAGE ROOM, SHED/ NEW STORM WINDOWS IN THE LIVING ROOM AND BREAKFAST AREA. That provide ample of natural light. Solar outdoor lights around of the home. This home offers 4 bedrooms and one room for a theatre of nursey attached to the master bedroom with 2 bathrooms. Family friendly neighborhood near a great park, walking trails and a pond. You\'ll find tasteful updates throughout this stunning home. Schedule a tour today! Refrigerator, microwave, washer and dryer is staying with the home.' ,`Acres` = '0.2273' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 1 CHAPARRAL VILLAGE SEC 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chaparral Village Sec 04' ,`TaxAmount` = '4576' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289180' WHERE `Matrix_Unique_ID` = '214066100' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:38:15.837' ,`MLSNumber` = '93365479' ,`ListAgentFullName` = 'Joann Cardona' ,`ListOfficeName` = 'Evolve Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.097431' ,`Longitude` = '-95.278841' ,`PhotoCount` = '12' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Hills' ,`StreetNumber` = '18638' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the highly sought after neighborhood of Summer Hills! Perfect location close to everything! This home receives you with an open floor plan concept, perfect for entertaining guests this holiday season! This beauty boasts a huge oversized driveway and fenced backyard with many trees offering shade and fresh air. NO FLOOD ZONE HERE! Contact Listing Agent to schedule your private tour. No showings until 10/31/2022.' ,`Acres` = '0.3719' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER HILLS 01, LOT 203' ,`LotDesciption` = 'Wooded' ,`LotSize` = '16200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Summer Hills 01' ,`TaxAmount` = '4586' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289180' WHERE `Matrix_Unique_ID` = '214071255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:10:00.200' ,`MLSNumber` = '93460670' ,`ListAgentFullName` = 'Terri Clasen' ,`ListOfficeName` = 'Pat Griffin Realty ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542283' ,`Longitude` = '-95.243646' ,`PhotoCount` = '36' ,`PostalCode` = '77581' ,`RoomCount` = '5' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Hollow' ,`StreetNumber` = '1804' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated, move-in ready home. Oakbrook Subdivistion offers top rated schools, and a great location for shopping with access to beltway 8 and Pearland Parkway. The home has been updated with neutral finishes and is ready for its new owners. When you arrive, you will note the easy to maintain landscaping, and yard. The AC system was replaced in 2022. Inside, the home is thoughtfully designed with a split floor plan, tile throughout the living spaces, with updated fixtures. The 3 bedrooms each have walk-in closets. The kitchen looks out onto a shaded backyard, and offers a charming eat-in area, and access to the covered patio. Please schedule your showing today.' ,`Acres` = '0.1607' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'OAKBROOK SEC 3 (A0070 W D C HALL)(PEARLAND) BLK 15 LOT 41' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '267' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'RUSTIC OAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Oakbrook Sec 3' ,`TaxAmount` = '5621' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289180' WHERE `Matrix_Unique_ID` = '214074749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:56:27.900' ,`MLSNumber` = '67562947' ,`ListAgentFullName` = 'Mia Li' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553194' ,`Longitude` = '-95.376858' ,`PhotoCount` = '30' ,`PostalCode` = '77584' ,`RoomCount` = '4' ,`ListPrice` = '488800.00' ,`Status` = 'Active' ,`StreetName` = 'Weatherford' ,`StreetNumber` = '2903' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3613' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sensationally Sophisticated Two-Story Home in Pearland! Centrally located in a highly coveted community within an excellent school district. Drenched in luminous natural light, the interior mesmerizes with an inviting foyer, a chic catwalk, an openly flowing floorplan, durable tile flooring and designer color scheme. Designed to appeal for modern entertaining, the semi-open concept kitchen features SS appliances, granite countertops, white cabinetry, a center island, and an adjoining great room with towering two-story ceilings and a cozy gas fireplace. Blissful evenings and tranquil mornings are easy in the enormous main-level primary bedroom with a deep closet, gleaming wood flooring, and an en suite featuring a jetted soaking tub, a separate shower, a built-in makeup vanity, and dual vanities. Three additional bedrooms are abundantly sized and may also be perfect for guests or home offices. Newer roof (2019).' ,`Acres` = '0.1263' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WEATHERFORD PHASE I AT SILVERLAKE (A0539 H T & B) BLK 3 LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '640' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Weatherford Ph I At Silverl' ,`TaxAmount` = '8843' ,`TaxRate` = '2.3537' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289181' WHERE `Matrix_Unique_ID` = '214156123' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T23:29:46.160' ,`MLSNumber` = '77923787' ,`ListAgentFullName` = 'Tami Shipley Govreau' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802318' ,`Longitude` = '-95.154550' ,`PhotoCount` = '33' ,`PostalCode` = '77530' ,`RoomCount` = '8' ,`ListPrice` = '238900.00' ,`Status` = 'Active' ,`StreetName` = 'Welbeck' ,`StreetNumber` = '14903' ,`StreetSuffix` = 'Drive' ,`City` = 'Channelview' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is large home for Sterling Green, with lots of square footage. Updated kitchen and bathroom counters and sinks, with freshly painted interior. Very spacious living room and a huge sunroom with separate cool air unit. Roof is approximately 5 years old. Spacious corner lot. This home is ready to move in and apply your personal style and touches to it. Low HOA with lots of amenities. Area pool, tennis court, pavilion, park. Call today to schedule your personal tour.' ,`Acres` = '0.22' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3 STERLING GREEN SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9583' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '270' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Green Sec 04' ,`TaxAmount` = '4555' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289181' WHERE `Matrix_Unique_ID` = '214156195' --> 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','214157053','1667289181','214157053','2022-10-31T23:50:46.550','65961895','Justin Chakkalayil','MIH REALTY, LLC','','','29.482459','-95.415496','50','77583','11','1099900.00','Active','Arbor Park Drive','4514','','Iowa Colony','5','1','5','4272','Single-Family','Brand New !! Never Lived in !! More than ½ Acre Lot in a Gated subdivision !! plenty of space to make your imagination in to reality!! 5 Bedroom 5 .5 bathroom!! Home office! 3 car garage! Media and game room! Master and additional bedroom downstairs! Upgrades galore! Enjoy the Open Floor plan with high Ceilings & Large Windows. Beautiful Kitchen with upgraded custom cabinets, walk- in pantry, Large Island & Stainless Steel Appliances. Inviting upgraded double wide entry door! huge family room with fireplace. Large Extended Patio with hot and cold water connections and drainage access for your outdoor kitchen! Large Master Bedroom has beautiful windows with beautiful back yard view. Master bath comes with Large Garden Tub separate step-down shower, Double Sinks & Huge Walk-In Closet. All secondary bedrooms have its own bathrooms. This master planned community has club house, parks pool and much more!! Rare find !! schedule your showing now!','','5','Perry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Alvin North','Central Gas','1','Lot 15 , Block 1','Cleared,Subdivision Lot','29233','Survey','','1200','1','Never Lived In','3','Convection Oven,Electric Oven,Gas Oven,Single Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Appraisal','2','Traditional','Meridiana','','','Public Sewer,Public Water,Water District','2022','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','214195709','1667289181','214195709','2022-10-31T23:06:40.410','73870022','David Cole','First Class, Realtors®','','','29.742319','-95.632933','50','77077','17','3000000.00','Active','Chatham Creek','2407','Court','Houston','6','2','5','8404','Single-Family','Truly Custom Mediterranean Home located on one of the best waterfronts in the neighborhood. The property has 180-degree view of the lake, and you can just sit and feel the tranquility on this location. The property features Beautiful double medal doors, a double stairs entry with a gorgeous chandelier. Arch niches throughout the property. Mirrored dance studio/exercise room. 4 car garage with built-ins. Plenty of living and entertaining areas. The primary bedroom and primary bath are must-see along with the custom walk-n closets. The Gourmet kitchen has a Sub-Zero Refrigerator, 5 burner gas range, and Wolf double ovens. All of the marble floors have been imported and the attention to detail is obvious once you drive up the extra-wide driveway. The home is located in a 24-Hour Guard Gated Community. This home shows a pride of ownership, and you feel the positive energy once you enter it. The views of the lake from every room downstairs are priceless. Motivated seller says bring offers.','0.2697','31','Kickerillo Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','4','Energy Corridor','Central Gas','1','LT 5 BLK 3 LAKES OF PARKWAY SEC 16 AMEND 2','Cul-De-Sac,Subdivision Lot,Water View,Waterfront','11749','Appraisal District','','2500','0','','4','Gas Oven','0','','','Gas Range','','Tile','27 - Houston','BUSH ELEMENTARY SCHOOL (HOUSTON)','WESTSIDE HIGH SCHOOL','WEST BRIAR MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Contemporary/Modern,Split Level,Traditional','Lakes of Parkway','44944','2.3907','Public Sewer,Public Water,Water District','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:14:07.360' ,`MLSNumber` = '33377406' ,`ListAgentFullName` = 'Susana Ortiz' ,`ListOfficeName` = 'First Texas Realty' ,`SellingAgentFullName` = 'Tracie Golden' ,`SellingOfficeName` = 'JPAR-The Sears Group' ,`Latitude` = '29.563596' ,`Longitude` = '-95.817232' ,`PhotoCount` = '9' ,`PostalCode` = '77471' ,`RoomCount` = '6' ,`ListPrice` = '238000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Avenue D' ,`StreetNumber` = '1005' ,`StreetSuffix` = '' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House is larger then description (approx. 1600sq ft). Completely remodeled from the outside to the inside. New attractive driveway and sidewalk. New doors through out. Recent roof. Recently renovated a/c, bathrooms, kitchen, flooring, plumbing, electrical etc. Large fenced yard. Shed with a/c unit and lighting. On an established quiet neighborhood. Bedroom sizes are approximate sizes. NO HOA and LOW TAXES. Never Flooded! A must see and close to everything. More pictures and docs coming soon.' ,`Acres` = '0.1377' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RIVERSIDE TERRACE SEC 3, BLOCK 1, LOT 12' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'JACKSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Riverside Terrace Sec 3' ,`TaxAmount` = '1386' ,`TaxRate` = '2.0748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289181' WHERE `Matrix_Unique_ID` = '214205800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-31T22:40:09.680' ,`MLSNumber` = '80135186' ,`ListAgentFullName` = 'Traci Garner' ,`ListOfficeName` = 'RE/MAX Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.997482' ,`Longitude` = '-95.409865' ,`PhotoCount` = '28' ,`PostalCode` = '77073' ,`RoomCount` = '5' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Southhook' ,`StreetNumber` = '20918' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You must see this completely remodeled 3/2/2 home. All new appliances and beautifully appointed kitchen with quartz countertops. Super large living areas. Fresh painr, New flooring, new ceramic tiles in bathrooms. This home will not last, schedule you r private tour today!!' ,`Acres` = '0.1434' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 2 NORTHRIDGE PARK WEST SEC' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'EICKENROHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northridge Park West Sec' ,`TaxAmount` = '4713' ,`TaxRate` = '2.5554' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667289181' WHERE `Matrix_Unique_ID` = '214239834' --> 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','214246084','1667289181','214246084','2022-10-31T23:43:34.950','45561310','Anansia Redmon','NB Elite Realty','','','29.615089','-95.396921','0','77047','9','325000.00','Active','City Garden','12710','Place','Houston','2','1','4','1852','Single-Family','Located In City Park , Beautiful, spacious home awaiting your family. Charming 4 Bedroom, two and a half bath, two story home with 2 car garage. The first floor offers an open living space with seamless flow from living to kitchen great for entertaining. First floor Primary bedroom has ensuite that has his and her sinks and separate shows and tub. Home is conveniently located minutes from downtown , Medical center and Minute Maid Park. Home is also gives easy access to 288, 610 and Beltway. Schedule your showing today. Home also has paying tenants, whom are willing to move. Please do not disturb.','0.102','3','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure,Tenant Occupied','1','','0','Five Corners','Central Electric','1','LT 55 BLK 1 CITY PARK SOUTH SEC 5','Subdivision Lot','4442','Appraisal District','','1275','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','ALMEDA ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','LAWSON MIDDLE SCHOOL','Appointment Required,Controlled Access,Supra Keybox,Temporarily No Showings','Appraisal District','2','Contemporary/Modern','City Park South','6950','3.0307','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214257914','1667289182','214257914','2022-10-31T23:13:48.220','54147550','Tracina Morris','eXp Realty, LLC','','','29.944242','-95.239222','30','77396','7','489900.00','Active','Pennymill','9914','Drive','Humble','3','1','4','3664','Single-Family','WESTIN HOME! Enjoy the luxuries of this immaculate home located in the gated community of Canyon Gate at Park Lake. This gem is only missing 1 thing... YOU! Well kept, 4 bedroom, 3 and a half bathrooms with 2 car garage. This beauty catches your eye at its entry way with a beautiful rotunda and high ceiling leading into the living area. This home also features a custom movie room and game room area perfect for entertaining. Enjoy the bonus of the Garage charging port for your electric vehicles. Conveniently located minutes away from IAH airport, Downtown and Restaurants.','0.2014','1','WESTIN HOMES','','','','Sellers Disclosure','','','1','Humble Area East','Central Gas,Zoned','1','LT 9 BLK 1 CANYON GATE AT PARK LAKES SEC 9','Other','8775','Appraisal District','','1200','0','','','','0','','','','','Composition','29 - Humble','PARK LAKES ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Canyon Gate/Pk Lakes Sec 9 D 9','9696','2.9873','Public Sewer,Public Water,Water District','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','214259565','1667289182','214259565','2022-10-31T22:06:11.050','61710644','Binh Vo','RE/MAX Northwest, REALTORS','','','30.012959','-95.630951','36','77429','9','370000.00','Active','Bent Gulch','14607','Lane','Cypress','2','0','4','2358','Single-Family','Beautiful home in the gated section of Enclave at Northpointe! This move-in ready home is offering an office with a wall of built-ins, 4 generously sized bedrooms, 2 baths and open concept kitchen and living area are perfect for your large gatherings. The air-conditioned sunroom is perfect for home gym or kid(s) playroom, With the oversized yard and plenty of room for a pool or outdoor activities! Boasting pressed quartz countertops in the kitchen, Cozy fireplace with pre-wire for surround sound, Whole house filtered and drinking water, and gorgeous designer tile and carpeting are just some of the perks this home offers. Refrigerator, washer and dryer included! This one won\'t last long!','0.2346','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Tomball South/Lakewood','Central Gas','1','LT 36 BLK 1 ENCLAVE AT NORTHPOINTE SEC 1','Subdivision Lot','10219','Appraisal District','','1190','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','53 - Tomball','WILDWOOD ELEMENTARY SCHOOL','TOMBALL MEMORIAL H S','WILLOW WOOD JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Enclave/Northpointe','8146','3.0164','Public Sewer,Public Water,Water District','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214259807','1667289182','214259807','2022-10-31T22:14:07.250','79640852','Syed Abidi','eXp Realty, LLC','','','29.820510','-95.332980','22','77016','7','325000.00','Active','Lynnfield','3820','Street','Houston','2','1','3','1761','Single-Family','BRAND-NEW DEVELOPMENT! This new build is a 2-story, single-family 3 bedrooms, 2 ½ bath house, located near 610 and I-45. It allows access to the wonders of Houston! Just minutes away from Downtown Houston - the property is ideal in all respects. The most exceptional quality of the house is its open-floor plan with high ceilings. The first floor houses the kitchen, dining/living area, and a half-bathroom, whereas the second story includes the Master Suite, master bath, separate soaker tub and shower, and walk-in closet. This home is enhanced with modern finishes; the kitchen includes stainless steel appliances, nice cabinets, Quartz countertops, large island, the rest of the home includes luxuries such as a Smart Thermostat, security cameras, iron fence gate with remote and keypad entrance, and a Ring Doorbell. Ethernet and cable outlets, and the bathrooms are lined with porcelain tile. Call to schedule a tour to see how you can make this house your home.','','2','Think Beyond Constru','','Gas Dryer Connections,Washer Connections','','Owner/Agent','1','','','Northside','Central Gas','0','LT 2 BLK 1 LYNNFIELD STREET HOMES','Cleared','4125','Appraisal District','','','1','Never Lived In','2','Convection Oven,Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','PAIGE ELEMENTARY SCHOOL','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','No Supra Keybox','Appraisal District','2','Mediterranean','LYNNFIELD STREET HOMES','','','Public Sewer,Public Water','2022','Builder'); --> 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','214260623','1667289182','214260623','2022-10-31T22:48:49.263','34133341','Cynthia Hodges','Broussard\'s Real Estate Invest','','','29.767133','-95.268391','0','77029','7','177500.00','Active','Fannette','8735','Street','Houston','1','0','3','1336','Single-Family','Well kept 3 bedroom 1 bath home inside loop 610. Original oak hardwood flooring. Nice sized formal living room and den...perfect for entertaining! Ceiling fans and window coverings throughout. Spacious indoor laundry and utility room. Ample closet space. Kitchen equipped with 5 burner gas cook top stove, wall oven, and plenty of cabinet space. Dining room has patio doors that lead to the patio and back yard enclosed with a privacy fence. Double drive-way and carport.','0.1324','2','','','Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','0','','','Denver Harbor','Central Gas','0','LT 131 BLK 7 PLEASANTVILLE SEC 8','Subdivision Lot','5768','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','PLEASANTVILLE ELEMENTARY SCHOOL','FURR HIGH SCHOOL','HOLLAND MIDDLE SCHOOL (HOUSTON)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Ranch','Pleasantville','1977','2.3307','Public Sewer,Public Water','1957','Appraisal District'); --> New record created successfully