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-11-13T08:25:40.453' ,`MLSNumber` = '25822388' ,`ListAgentFullName` = 'Diana Nickell' ,`ListOfficeName` = 'Texas Palladium Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723778' ,`Longitude` = '-95.004078' ,`PhotoCount` = '33' ,`PostalCode` = '77520' ,`RoomCount` = '10' ,`ListPrice` = '204999.00' ,`Status` = 'Active' ,`StreetName` = 'New Jersey' ,`StreetNumber` = '2209' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A historic beauty in Baytown close to a family friendly park and the coast. Lots of updates and NO CARPET!!! Check out the floorpan. Space for an office, dining/living combo and the primary bedroom is on the first floor. Two car detached garage with work area. Located on a large corner lot with unique garage entrance from the back of the property. Call to view this lovely home with custom cabinetry and new flooring throughout.' ,`Acres` = '0.2268' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 25 & 26 BLK 33 EAST BAYTOWN' ,`LotDesciption` = 'Corner' ,`LotSize` = '9878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'East Baytown' ,`TaxAmount` = '4421' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1934' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418620' WHERE `Matrix_Unique_ID` = '209233434' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:00:13.897' ,`MLSNumber` = '57148939' ,`ListAgentFullName` = 'Bennett Onwuchekwa' ,`ListOfficeName` = 'B & G Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681093' ,`Longitude` = '-95.677359' ,`PhotoCount` = '50' ,`PostalCode` = '77083' ,`RoomCount` = '4' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Keegans Ridge Way' ,`StreetNumber` = '16651' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1263' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'KEEGANS RIDGE SEC 2, BLOCK 5, LOT 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Georgian' ,`Subdivision` = 'Keegans Ridge Sec 2' ,`TaxAmount` = '5717' ,`TaxRate` = '2.5157' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418620' WHERE `Matrix_Unique_ID` = '210038193' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:16:35.980' ,`MLSNumber` = '29374494' ,`ListAgentFullName` = 'Jessica Gunn' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.791296' ,`Longitude` = '-95.524392' ,`PhotoCount` = '22' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedarpost Square Street' ,`StreetNumber` = '9515' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2339' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite wood flooring, granite countertops in kitchen, stainless steel appliances, separate wet bar with wine refrigerator, and separate media section! This home has the option to transfer furnishings as well as a refrigerator, washer, and dryer. The primary bathroom features a walk-in shower with a separate garden tub and is connected to an extra-large bedroom. Privacy, elegance, and low maintenance are what you can expect with this home! Only minutes away from Energy Corridor & City Centre in a gated community. This home also has a grant program available for buyers that qualify.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Blk 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '2016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2304' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cedarpost Square' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418620' WHERE `Matrix_Unique_ID` = '210322126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:07:01.153' ,`MLSNumber` = '72883813' ,`ListAgentFullName` = 'Tatiana Hernandez' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.020023' ,`Longitude` = '-95.167637' ,`PhotoCount` = '45' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '344500.00' ,`Status` = 'Active' ,`StreetName` = 'Water Point' ,`StreetNumber` = '19407' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful house is located within walking distance of Lake View Park. This cozy four-bedroom, two-and-a-half-bathroom, two-story home will make you feel welcome the minute you step in the front door. Instantly when entering you would find a formal office across the formal dining and which both have French doors for privacy. The living room with a gas fireplace is open to the kitchen and the breakfast area where you can enjoy the view of the patio and all the natural light that comes from the bay windows. The primary bedroom is found on the second floor opposing the 3 bedrooms. The Game roomi s also located on the 2nd floor. Call to schedule a private showing' ,`Acres` = '0.1836' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 KINGS RIVER VILLAGE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings River Village Sec 6' ,`TaxAmount` = '6266' ,`TaxRate` = '2.453' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418621' WHERE `Matrix_Unique_ID` = '210593001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:27:52.207' ,`MLSNumber` = '38710624' ,`ListAgentFullName` = 'Deann Morales' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Jamie Butler' ,`SellingOfficeName` = 'Brighthouse Realty, LLC' ,`Latitude` = '30.371205' ,`Longitude` = '-95.531833' ,`PhotoCount` = '40' ,`PostalCode` = '77304' ,`RoomCount` = '11' ,`ListPrice` = '500000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brimstone Hill' ,`StreetNumber` = '5863' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3244' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dreaming of living the lake life? Wishing you owned a big house that is not right on top of your neighbors? Well look no further - this home has it all! This 4 bedroom Smart home (can be 5 - study has a closet & full bath close by) also has 2 bedrooms down, plus study & formal dining room. Gorgeous wall of windows in the open concept kitchen, living & breakfast make this home light & bright. Additional cabinets, countertop & LED LIGHTING has been added to this already awesome kitchen to really give it the wow factor! 5 burner gas cooktop & walk-in pantry. The primary suite is HUGE and overlooks the beautiful backyard. His & her sinks, soaking tub & separate shower + big walk in closet. Upstairs has 2 additional bedrooms + game room. AMAZING BACK YARD! Almost half an acre on a cul-de-sac! The owner has really transformed this area with gardens, fencing, lighting & separate irrigation meter. Tons of upgrades see list. Boat dock in neighborhood + great pools, trails etc. NEVER FLOODED.' ,`Acres` = '0.3758' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S954414 - WATER CREST ON LAKE CONROE 14, BLOCK 1, LOT 22' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt' ,`LotSize` = '16372' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Water Crest On Lake Conroe 14' ,`TaxAmount` = '9863' ,`TaxRate` = '3.0823' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418621' WHERE `Matrix_Unique_ID` = '210916126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:54:43.170' ,`MLSNumber` = '3224108' ,`ListAgentFullName` = 'Paige Houston' ,`ListOfficeName` = 'Texas Real Estate Pro' ,`SellingAgentFullName` = 'Ashley DeCastro' ,`SellingOfficeName` = 'City Insight Houston' ,`Latitude` = '29.961299' ,`Longitude` = '-95.198657' ,`PhotoCount` = '34' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '475000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Woodnote' ,`StreetNumber` = '12111' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous one story nestled in the highly sought after Groves.4 bedroom, 3 bathroom Perry MOVE IN READY home. Brick and stone elevation & beautiful landscaping enhance the curb appeal. Elegant extended entry with 13-foot ceilings leads to open kitchen, dining area and family room. Easy to care for wood look tile throughout all main areas. Home features an additional space off of the entry with glass doors perfect for a game room or home office. Spacious family room with a wall of windows opens to the kitchen and morning area. The kitchen features an oversized island with built in seating, white cabinets, granite countertops and stainless steel appliances. The primary bedroom is bright and airy with a wall of windows and 12 ft ceilings. The primary bathroom includes a corner garden tub, separate shower, dual vanities, linen closet and a large walk-in closet. OVERSIZED COVERED BACK PATIO perfect for entertaining! Home features a sprinkler system. Two-car garage.' ,`Acres` = '0.1728' ,`Area` = '1' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 GROVES SEC 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7526' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '282' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '13262' ,`TaxRate` = '3.5373' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418621' WHERE `Matrix_Unique_ID` = '211259634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:47:34.823' ,`MLSNumber` = '61757663' ,`ListAgentFullName` = 'Jonathan Denissen' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = 'Adeyinka Adeyemo' ,`SellingOfficeName` = 'FYI Realty-Katy' ,`Latitude` = '29.891374' ,`Longitude` = '-95.739948' ,`PhotoCount` = '20' ,`PostalCode` = '77433' ,`RoomCount` = '3' ,`ListPrice` = '285400.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Tuscan Cypress' ,`StreetNumber` = '7931' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1381' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Construction 1 Story Saratoga Home, the Mockingbird, located in the new community Cypress Oaks North. Home has 3 bedrooms, Master Bedroom with ensuite, 2 Bathrooms and a 2 car attached garage. Home has an open floor plan perfect for entertaining. The kitchen has a large island with granite countertops, custom tile back splash, and ceramic tile flooring. Master Suite complete with double sinks. Check out the 3D Tour!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 CYPRESS OAKS NORTH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Oaks North' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668418621' WHERE `Matrix_Unique_ID` = '211400837' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:31:31.193' ,`MLSNumber` = '54575691' ,`ListAgentFullName` = 'Rena Rasmijn' ,`ListOfficeName` = 'Central Metro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.455380' ,`Longitude` = '-95.029386' ,`PhotoCount` = '21' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou' ,`StreetNumber` = '3406' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FIXER-UPPER.....Per Seller home has never flooded - Come check out this corner lot that sits on 1.364 acres. The land alone offers many opportunities to create your own oasis. Custom built shop with a 2,440 sq ft, 3 bed 2 bath garage apartment just above. All with custom finishes and ready to live in as it sits. The shop has been well insulated and is ready to store all of your equipment in or use to your liking. The main home is a 4 bed 2 bath home that need tons of work and cannot be lived in at the moment, PHOTOS ARE ATTACHED BUT WILL BE UPDATED AFTER HOME AND LOT ARE CLEARED.\r\n\r\n**ALL PERSONAL BELONGINGS ARE BEING REMOVED FROM HOME AND THE LOT ITSELF***' ,`Acres` = '1.364' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 208 PAGE 1 W WILSON SUR TR 58 1.364 ACRS' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '59416' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = '0' ,`TaxAmount` = '7903' ,`TaxRate` = '2.5699' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418622' WHERE `Matrix_Unique_ID` = '211918362' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:22:34.973' ,`MLSNumber` = '54358773' ,`ListAgentFullName` = 'Jeffrey Sadler' ,`ListOfficeName` = 'Sadler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.470554' ,`Longitude` = '-95.531201' ,`PhotoCount` = '33' ,`PostalCode` = '77459' ,`RoomCount` = '7' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Trail' ,`StreetNumber` = '8754' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning single story home situated on an OVERSIZED PREMIUM LOT in Sienna. Sophisticated style & exquisite design, leaves this home showing like a model! Newly built in 2021, enjoy the \"new construction\" feel of this lightly lived-in home & take advantage of all the UPGRADES! Impressive stone & brick exterior & custom glass leaded front door greet you upon arrival. Study w/ closet & french doors/4th bedroom located off entry. Designer wood-like tile flows thruout. Live & entertain w/ style in the open concept design, w/ seamless spaces that flow from the kitchen & brfst room to the spacious family room w/ custom stone fireplace. Create a culinary masterpiece in the fabulous kitchen w/ expansive island plus brfst bar, quartz countertops, SS appliances, lots of cabinetry & two pantries. The primary suite offers a spa-like bath & walk-in closet connecting to laundry room. Spacious secondary bedrooms. Extended covered patio leads to the large pool sized backyard w/ endless possibilities.' ,`Acres` = '0.2276' ,`Area` = '38' ,`BuilderName` = 'Chesmar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA PLANTATION SEC 28, BLOCK 2, LOT 7' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9912' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'SIENNA' ,`TaxAmount` = '1107' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418622' WHERE `Matrix_Unique_ID` = '211994413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:09:15.310' ,`MLSNumber` = '52530743' ,`ListAgentFullName` = 'Shamim Momin' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.087513' ,`Longitude` = '-94.182456' ,`PhotoCount` = '26' ,`PostalCode` = '77706' ,`RoomCount` = '7' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Westgate' ,`StreetNumber` = '6945' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2715' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller will contribute for buying down points. Beautiful 3 bedroom and 2 & 1/2 bath home in Dowlen West! This home has both formal area and living area with fireplace. Huge kitchen with white cabinet and granite countertop. Stunning polished Hardwood floor on the first floor and newly installed waterproof vinyl flooring on the second floor. No Carpet. FRESH PAINT in the entire house.Newly remodelled bathrooms with updated standing showers. Beautiful newly upgraded wood staircases. Zoned to great schools. Schedule your appointment today!' ,`Acres` = '0.2361' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'DOWLEN WEST UNIT 16 L7 B32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10285' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CURTIS ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dowlen West' ,`TaxAmount` = '5914' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418622' WHERE `Matrix_Unique_ID` = '212014329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:36:18.910' ,`MLSNumber` = '1034898' ,`ListAgentFullName` = 'Geraldine Ray' ,`ListOfficeName` = 'Geri Ray Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.581260' ,`Longitude` = '-95.222494' ,`PhotoCount` = '13' ,`PostalCode` = '77089' ,`RoomCount` = '8' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Sagegreen' ,`StreetNumber` = '11518' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location - Corner lot on cul-de-sac with sparkling pool in private back yard. *Surrounded by neighbors with camaraderie \r\n*Custom white kitchen cabinets featuring granite countertops and an adjoining extensive butler\'s pantry with open front shelving to display all your small appliances and extra cooking essentials. *Additional room for a second fridge or freezer in that pantry area. \r\n*Tile flooring throughout.\r\n*Formal living room/office accesses primary bedroom via double French doors.\r\n*Both bathrooms updated with glass enclosed showers and marble topped vanities.\r\n*Entire pex water piping throughout. \r\n*Huge water heater and ample counter topped cabinets in laundry area.\r\n*Complete update after Hurricane Harvey.' ,`Acres` = '0.1864' ,`Area` = '3' ,`BuilderName` = 'PERRY' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 17 SAGEGLEN SEC 2' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '8120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '262' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEBER ELEMENTARY' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sageglen Sec 02' ,`TaxAmount` = '5116' ,`TaxRate` = '2.356' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418622' WHERE `Matrix_Unique_ID` = '212031267' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:44:03.747' ,`MLSNumber` = '75279912' ,`ListAgentFullName` = 'Erika Jones' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = 'Jerelynn Smith Foy' ,`SellingOfficeName` = 'Sky Real Estate Professionals' ,`Latitude` = '30.260651' ,`Longitude` = '-95.705115' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '638500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Magnolia Reserve' ,`StreetNumber` = '121' ,`StreetSuffix` = 'Loop' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pristine brick and stone home is like new and improved! Nestled among the trees on a .62 acre property, it has all of comfort and luxury you deserve. A Must See Supreme Summer Kitchen w/1,158 sq\' of covered outdoor living. Too many upgrades to list. Cedar fenced backyard w/ spectacular sunset & wooded views. 8ft Mahogany glass front door greets you to a Foyer and Formal Dining Room graced with rich wood flooring. The open concept is designed to impress! Soaring ceiling, walls of windows, and elegant fireplace welcomes you to spacious Family Room. Bright white Chef\'s kitchen has loads of storage, large island, SS appliances, and Breakfast Area. Butler\'s Pantry & huge walk in pantry takes the kitchen over the top! The Media Room includes Sonos surround sound speakers, wall sconce lighting, ceiling fan and a closet. Spacious Primary Suite has a luxurious Ensuite Bathroom. Bedroom #2 has Ensuite Bath while 2 other bedrooms share the hallway Bath. This home is a Staycation!' ,`Acres` = '0.6206' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S712300 - MAGNOLIA RESERVE 01, BLOCK 4, LOT 6' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '27032' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '726' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Reserve' ,`TaxAmount` = '8119' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418622' WHERE `Matrix_Unique_ID` = '212074475' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:34:29.277' ,`MLSNumber` = '97522260' ,`ListAgentFullName` = 'Lauren Harris' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800986' ,`Longitude` = '-95.402646' ,`PhotoCount` = '33' ,`PostalCode` = '77008' ,`RoomCount` = '12' ,`ListPrice` = '1699000.00' ,`Status` = 'Active' ,`StreetName` = '17th' ,`StreetNumber` = '325' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Light filled contemporary home blended with classic Heights style in this new luxury build. Charming front porch and gated front yard. Entryway greets you with soaring 10 foot high ceilings, gorgeous hardwood flooring, and neutral paint colors. An entertainer’s dream layout: state-of-the-art island kitchen with quartz waterfall countertops, Wolf range + double ovens, Sub Zero refrigerator, butler’s pantry with wine fridge, formal dining room, breakfast room + massive living room with built in cabinetry. Covered patio with summer kitchen, Big Green Egg, Napoleon grill + burner that overlook the turfed lawn and swimming pool! 1/1 guest house just off of the summer kitchen. Second level with generously sized primary suite, game room, two secondary bedrooms + full bathroom. Home is on an oversized lot and is walking distance to hike and bike trail, iconic dining + shopping on 19th street. A Heights home that checks every box!' ,`Acres` = '0.1515' ,`Area` = '9' ,`BuilderName` = 'IBuild Concepts LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 36 & 37 BLK 120 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '9691' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418623' WHERE `Matrix_Unique_ID` = '212511168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:02:12.983' ,`MLSNumber` = '24112201' ,`ListAgentFullName` = 'Bennett Onwuchekwa' ,`ListOfficeName` = 'B & G Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679774' ,`Longitude` = '-95.693957' ,`PhotoCount` = '34' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Silent Hills' ,`StreetNumber` = '9014' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1908' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2205' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MISSION SIERRA SEC 4, BLOCK 2, LOT 34' ,`LotDesciption` = 'Other' ,`LotSize` = '9603' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '860' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Mission Sierra Sec 4' ,`TaxAmount` = '5236' ,`TaxRate` = '2.4429' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418623' WHERE `Matrix_Unique_ID` = '212523057' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:21:00.237' ,`MLSNumber` = '95129691' ,`ListAgentFullName` = 'Kevin Harberson' ,`ListOfficeName` = 'eXp Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.391177' ,`Longitude` = '-95.413863' ,`PhotoCount` = '31' ,`PostalCode` = '77303' ,`RoomCount` = '10' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 2432' ,`StreetNumber` = '10677' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beauty is 4745 s.f. on 2.853 unrestricted, cleared acres, in one of the fastest growing areas of Conroe. Veranda all the way around. Downstairs- oversized Bdrms, HUGE Walk-in Closets. 3 Perfectly Remodeled Bathrms, One Great Room,Kitchen w/elegant Quartzite countertops,Extra Large island, flows to the dining area and into living area! Flex Rm can be anything! Office off of the hallway w/beautiful sliding barn door.Utility/Mud Room room can fit W/D,freezers,shelves for food and more! UPSTAIRS has tons of room too. Living area, Bedroom and xtra Flex Rm. New A/Cs, Roof 5yrs, conventional septic.Built in 1983 & updated in the last 2 yrs. Home Was Restored Beautifully and Correctly!Photos and Video Speak For Themselves!Older building on property can stay or will be removed. Bring your own business here. Plenty of room!!! No Flooding! 2 tax I.D.s for 2.5 acres +.3829 acres. Horse head statues & C-Can do not convey w/sale.' ,`Acres` = '2.8829' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NORTHRIDGE, LOT 91, ACRES 2.500' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Northridge' ,`TaxAmount` = '' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418623' WHERE `Matrix_Unique_ID` = '212965067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:06:20.000' ,`MLSNumber` = '62186781' ,`ListAgentFullName` = 'LaTonya Rodney' ,`ListOfficeName` = 'The Christopher Dynasty Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542533' ,`Longitude` = '-95.504520' ,`PhotoCount` = '39' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Dry Creek' ,`StreetNumber` = '3322' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Sawyer II floorplan! This 2 story home boasts a 2 story foyer, 4 bedrooms, 3.5 baths, open concept kitchen/family room and a 2 car garage. The beautiful kitchen has granite countertops with recessed lighting and a farmhouse sink. The primary bedroom is on the first floor with vaulted ceiling. The primary bath has double sinks with separate tub and shower and walk-in closet. Upstairs has 3 secondary bedrooms, 2 bathrooms and an enormous loft. Beautiful, well maintained home that is a must see!' ,`Acres` = '0.1512' ,`Area` = '38' ,`BuilderName` = 'K Havnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'DRY CREEK VILLAGE SEC 2, BLOCK 3, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6586' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '890' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dry Creek Village Sec 2' ,`TaxAmount` = '1177' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668418623' WHERE `Matrix_Unique_ID` = '213045865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:55:58.563' ,`MLSNumber` = '34278550' ,`ListAgentFullName` = 'Brenda Hebert' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469143' ,`Longitude` = '-95.115400' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Amado' ,`StreetNumber` = '2001' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Plan #253 offers 4 bedrooms and 3 full bathrooms in the home, MASSIVE Bonus Room with Glass French Doors, in addition to a Formal Dining Room with dual access from different areas of the home (french doors off of the front entry and second door off of the kitchen). This plan offers a second primary suite perfect for MIL or Guests as it has its own full/private bathroom. This split floor plan has the primary suite in the back of the home and two additional bedrooms with a 3rd large bathroom at the front of the home. The kitchen is large with 42\" cherry cabinets, granite countertops, a large island, and it\'s open to the family room and breakfast area. There\'s a walk in pantry and a generously sized laundry room right off the kitchen. The garage is a 2.5 car in size with a full bathroom and a 2.5 car porte-cache provides covered parking; double wide driveway; quiet corner lot. New luxury vinyl floors throughout; new paint throughout. See Attachments for full list of updates by builder' ,`Acres` = '0.2311' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEDONA SEC 5 (2017) ABST 3, BLOCK 8, LOT 54, ACRES 0.23' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '10067' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAUERSCHLAG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sedona Sec 5' ,`TaxAmount` = '6067' ,`TaxRate` = '2.004626' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418624' WHERE `Matrix_Unique_ID` = '213208315' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:15:07.173' ,`MLSNumber` = '78026468' ,`ListAgentFullName` = 'Leon Shapiro' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.596313' ,`Longitude` = '-95.102156' ,`PhotoCount` = '26' ,`PostalCode` = '77059' ,`RoomCount` = '13' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Roaring Rapids' ,`StreetNumber` = '4007' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3231' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPDATED AND UPGRADED! GREAT 4+/3.5/2D BEAUTY WITH REPLACED CUSTOM SOFT CLOSE CABINETS IN KITCHEN WITH GRANITE COUNTER TOPS, BUTCHER BLOCK TOPPED ISLAND, STAINLESS SAMSUNG APPLIANCES INCLUDING FRENCH DOOR REFRIGERATOR, UNDERMOUNT SS SINK WITH BRUSHED GOLD PULLOUT FAUCET AND UPDATED LIGHTING. LUXURY VINYL PLANK FLOORING IN DEN, DINING, PRIMARY BEDROOM, STUDY, AND ENTRY - PRIMARY BATH HAS 12 X 24 TILE, FRAMELESS GLASS CORNER SHOWER, FREESTANDING TUB, DOUBLE SINKS, BRUSHED GOLD FAUCETS, PAINTED CABINETS AND GRANITE COUNTER TOPS. HIGH CEILINGS IN 2 STORY ENTRY, WROUGHT IRON STAIR RAILS WITH RED OAK STAIR TREADS, TILED FRONT PORCH, FRESH PAINT IN AND OUT, REPLACED ROOF 9/2022, REPLACED FRONT DOOR, REPLACED BACK DOOR, 2 INCH FAUX WOOD BLINDS, LED RECESSED LIGHTING AND LED BULBS, OILED BRONZE DOOR KNOBS AND MORE!' ,`Acres` = '0.223' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 10 BROOKWOOD SEC 1B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9714' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '745' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BROOKWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookwood' ,`TaxAmount` = '7511' ,`TaxRate` = '2.5419' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418624' WHERE `Matrix_Unique_ID` = '213271332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:48:33.820' ,`MLSNumber` = '10776387' ,`ListAgentFullName` = 'Miriam Brassfield' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000867' ,`Longitude` = '-95.630175' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '13' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Springmint' ,`StreetNumber` = '13107' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning custom estate home on large cul de sac lot! Your own oasis awaits you in the huge backyard with a covered patio, pool & spa. Lots of grassy area along with the fabulous pool. GORGEOUS entry chandelier! Beautiful hardwood floors in the downstairs entry, formal living area, office, den, primary bedroom. Hardwood Floors in upstairs game room & extra room! The extra room could be a play room, media room, extra study, workout room...whatever you need it to be. Gourmet island kitchen with a Viking 6 burner cooktop with a grill. Lots of cabinets and storage! Lots of custom detail everywhere you look from all the molding, Plantation shutters, wide baseboards and tiered ceilings, Cozy fireplace in Den & primary bedroom. You will find lots of custom built-ins. Abundance of storage. Secondary bedrooms are spacious with generous closets. The gate in backyard opens up to Lakewood Oaks lot where basketball, tennis and playground is! Gated driveway! What a wonderful place to call home.' ,`Acres` = '0.352' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 LAKEWOOD OAKS ESTATES SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15333' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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 District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Oaks Estates Sec 03' ,`TaxAmount` = '12765' ,`TaxRate` = '2.8937' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418624' WHERE `Matrix_Unique_ID` = '213393370' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:26:40.090' ,`MLSNumber` = '27854536' ,`ListAgentFullName` = 'Helen Nguyen' ,`ListOfficeName` = 'LV Realty & Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710778' ,`Longitude` = '-95.579401' ,`PhotoCount` = '23' ,`PostalCode` = '77072' ,`RoomCount` = '5' ,`ListPrice` = '234500.00' ,`Status` = 'Active' ,`StreetName` = 'Bugle' ,`StreetNumber` = '4323' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1532' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Updated single story 3/2/2 with wrap around courtyard and big backyard in convenient area. Newly renovated bathrooms, Carpet, Kitchen Cabinets, New Quart kitchen Countertop, Appliances, & Gas Range. Fresh Interior and Exterior Paint. Open Concept. High ceiling in the family room. Fire place. Primary bathroom has skylight ceiling and built-in cabinets, & standing shower. Easy to access to Beltway 8 and 59 S. Won\'t last long!' ,`Acres` = '0.1322' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 BRAYS VILLAGE SEC 2 R/P' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CHANCELLOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALIEF MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brays Village Sec 2' ,`TaxAmount` = '3673' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418624' WHERE `Matrix_Unique_ID` = '213467083' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:53:23.270' ,`MLSNumber` = '17804783' ,`ListAgentFullName` = 'Denise Martinez' ,`ListOfficeName` = 'Keller Williams Laredo' ,`SellingAgentFullName` = 'Denise Martinez' ,`SellingOfficeName` = 'Keller Williams Laredo' ,`Latitude` = '29.857817' ,`Longitude` = '-95.375680' ,`PhotoCount` = '44' ,`PostalCode` = '77076' ,`RoomCount` = '7' ,`ListPrice` = '223000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Connie' ,`StreetNumber` = '209' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bedroom, 1 bath house in the heart of north side. Minutes away from several restaurants, shopping, the Heights, Downtown, and several major highways allowing for an easy commute. No HOA; no restrictions. House features granite counters in kitchen; remodeled shower bath; original hardwood floors under carpet; remote control fireplace; new concrete driveway with lots of parking space; and beautiful yard with covered deck and canopies; Perfect for entertaining. Fridge, stove, washer and dryer stay with the house. Don’t miss out on this spectacular house! Schedule your showing today!!' ,`Acres` = '0.1922' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 2 BURBANK GARDENS SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DE CHAUMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'FONVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Burbank Gardens Sec 01 R/P' ,`TaxAmount` = '2322' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418624' WHERE `Matrix_Unique_ID` = '213563028' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:09:16.980' ,`MLSNumber` = '91503318' ,`ListAgentFullName` = 'Debra Shelly' ,`ListOfficeName` = 'Westchase Realty Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595340' ,`Longitude` = '-95.501030' ,`PhotoCount` = '29' ,`PostalCode` = '77489' ,`RoomCount` = '5' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Gatebriar' ,`StreetNumber` = '15838' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very motivated seller. Single family property; NOT a duplex, with large bedrooms and upgraded bathrooms and no carpeting. Master bedroom has his and her closets and remodeled bathroom with new tile, bathtub and sink. Master bedroom designer ceramic flooring. Secondary bedroom has a large walk in closet. Another bedroom can be added to the secondary bedroom. Secondary bathroom has new bathtub, tile and sink. Kitchen has all electrical appliances, new tiled floors and new stove. Kitchen has ample space for cooking. All plumbing replaced with PEX pipes per Seller. New garage door installed. Beautiful front and back yards. No MUD taxes. Lower interest rates available with select lenders. Call for details.' ,`Acres` = '0.1566' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BRIARGATE SEC 8, BLOCK 11, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BRIARGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargate Sec 8' ,`TaxAmount` = '3071' ,`TaxRate` = '2.2137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418625' WHERE `Matrix_Unique_ID` = '213800813' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:52:19.420' ,`MLSNumber` = '47562817' ,`ListAgentFullName` = 'Lacsmey Keo' ,`ListOfficeName` = 'Exit Realty Property Pros' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.078636' ,`Longitude` = '-93.789689' ,`PhotoCount` = '36' ,`PostalCode` = '77630' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cypress Wood' ,`StreetNumber` = '1005' ,`StreetSuffix` = 'Drive' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come fall in love with this gorgeous 3 years young home! Designated to the highly-sought Bridge City ISD, this 4/2/2 open floor plan home is what you\'ve been looking for. Features include: stainless steel appliances, 3 cm granite countertops with undermount sinks, wood plank tile floorings in living, hallways and wet areas, primary and guest bath with his/hers sinks, light and bright with neutral paints, inside utility room, a mud room and the list goes on. Enter through the entryway into the living room with a gas log fireplace. Enjoy the company of your family in the living area that opens up to the kitchen, which has a breakfast bar and plenty of cabinet spaces. Walk out into the covered porch and into the large fenced yard. This home also comes with all appliances, buyer 1 year home warranty and more! You won\'t want to miss this!' ,`Acres` = '0.1929' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CYPRESSWOOD VILLAGE PHASE I, LOT 46, ACRES 0.1929' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8403' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Village Ph I' ,`TaxAmount` = '6381' ,`TaxRate` = '2.5023' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418625' WHERE `Matrix_Unique_ID` = '213835817' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:38:48.727' ,`MLSNumber` = '8850033' ,`ListAgentFullName` = 'Fafu Zeng' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.047674' ,`Longitude` = '-95.394133' ,`PhotoCount` = '28' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '219800.00' ,`Status` = 'Active' ,`StreetName` = 'Earlmist' ,`StreetNumber` = '23326' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3-bedroom, 2 baths and 2 garage one story home!. Recently updated with tile flooring and new carpets. Fresh paint throughout inside and outside of the home. New appliances and new fans/lights. High vaulted ceiling family room with wood burning fire place and spacious kitchen/dining area. Huge backyard ready to entertain! Move in ready. Great schools nearby with awesome shopping centers down the road. Close to 1960 W, tollway, and near 45 N. Schedule your show today!' ,`Acres` = '0.168' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 5 TIMBER LANE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane Sec 6' ,`TaxAmount` = '3914' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418625' WHERE `Matrix_Unique_ID` = '213904211' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:07:01.230' ,`MLSNumber` = '64982292' ,`ListAgentFullName` = 'Zoya Alam' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.735276' ,`Longitude` = '-95.445016' ,`PhotoCount` = '27' ,`PostalCode` = '77027' ,`RoomCount` = '5' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Drexel' ,`StreetNumber` = '3311' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3285' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your urban oasis!! Lots of upgrades and beautiful finishes. Fully gutted and renovated bathrooms downstairs. Chef’s island kitchen with Thermador appliances and double stack oven. Swingset and some furniture left behind that can be included in the sale. Home has a spacious sunroom and a beautiful pool with a hot tub/spa. Oversized lot (11,495) with side yard/pergola and outside fireplace. Home has full perimeter mosquito spraying system. Fridge & washer/dryer included. Walking distance to Highland Village. Close proximity to The River Oaks District, Central Market, and The Galleria.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Highland Village/Midlane' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 2A & 3 BLK 8 LYNN PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11495' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Lynn Park' ,`TaxAmount` = '25976' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418625' WHERE `Matrix_Unique_ID` = '213910817' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:48:36.440' ,`MLSNumber` = '65276962' ,`ListAgentFullName` = 'Kendra Goolsby' ,`ListOfficeName` = 'Goolsby Properties' ,`SellingAgentFullName` = 'Neocia Farris' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.033877' ,`Longitude` = '-95.606439' ,`PhotoCount` = '37' ,`PostalCode` = '77422' ,`RoomCount` = '6' ,`ListPrice` = '425000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 506' ,`StreetNumber` = '3460' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1878' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '396’ of San Bernard River Frontage + Endless views from inside…it’s like a vacation at home. - This updated 3 bedroom, 2 bath home sits on 2 acres of pristine waterfront.. The home features an open living area, new floor to ceiling Pella windows, gas fireplace and island kitchen with 6 burner gas range and side by side ovens. Fully fenced yard has a shop with electricity, and plenty of room to roam. Situated on a private setting with sprawling oaks and just steps away from your private dock with a boat lift and vinyl bulkhead. You can enjoy boating, fishing or waterskiing without ever leaving home. You\'ll definitely want to hurry on this one!!' ,`Acres` = '2.14' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0138 S M WILLIAMS TRACT 8C,(NE/2) ACRES 2.14' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '93218' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'S M Williams' ,`TaxAmount` = '5962' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418626' WHERE `Matrix_Unique_ID` = '214003338' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:36:57.940' ,`MLSNumber` = '25853674' ,`ListAgentFullName` = 'Fafu Zeng' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.046296' ,`Longitude` = '-95.391047' ,`PhotoCount` = '29' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '249800.00' ,`Status` = 'Active' ,`StreetName` = 'Lone Wolf' ,`StreetNumber` = '23207' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1629' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1-story home with 3-bedroom, 2 baths and 2 attached garage!. Recently updated with new tile flooring and new carpets. Freshly painted throughout inside and outside of the home. New fans/lights. Huge high ceiling family room with a fire place. Spacious kitchen and a large formal dining open to the family room. Large backyard ready to entertain! Move in ready. Great schools with awesome shopping centers down the road. Close to I45, Hardy Tollway and all amenities. Schedule your show today' ,`Acres` = '0.1446' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 65 TIMBER LANE SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane Sec 07' ,`TaxAmount` = '5341' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418626' WHERE `Matrix_Unique_ID` = '214075927' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:35:35.170' ,`MLSNumber` = '79013410' ,`ListAgentFullName` = 'Roman Garza' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.970243' ,`Longitude` = '-95.439959' ,`PhotoCount` = '27' ,`PostalCode` = '77014' ,`RoomCount` = '8' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Plumwood' ,`StreetNumber` = '1475' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1990' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Welcome home to 1475 Plumwood Dr! This beautiful home, located in the community of Cranbrook, is simply spectacular inside and out! Offering 1,990 sqft of living space, 4 beautifully appointed bedrooms, 2 bathrooms, a wonderfully-equipped kitchen, and a bright and inviting living space! Boasting incredible attention to detail throughout including tile floors, gorgeous wood cabinetry, sleek fixtures, and modern finishes. The master ensuite bath is immaculate boasting a separate tub and shower, and so much more. Sitting on a beautiful 7,186 sqft lot with a well-maintained lawn and beautiful brick elevation this home offers a fantastic curbside appeal! Conveniently located near I-45 and Beltway 8 and just minutes away from Bush airport, Downtown, and The Woodlands. Close to shopping and restaurants! Book your private showing of this wonderful home today!' ,`Acres` = '0.1649' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 & TR 10 BLK 8 CRANBROOK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7183' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cranbrook' ,`TaxAmount` = '5172' ,`TaxRate` = '2.7192' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418626' WHERE `Matrix_Unique_ID` = '214076314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:32:11.813' ,`MLSNumber` = '67458467' ,`ListAgentFullName` = 'Leon Shapiro' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.458347' ,`Longitude` = '-95.089902' ,`PhotoCount` = '19' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Sun Terrace' ,`StreetNumber` = '3139' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1583' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! UPDATED 3/2/2 SPLIT PLAN BEAUTY IN BAY COLNY NORTHPOINTE. REPLACED FLOORING INCLUDES CARPET & LUXURY VINYL FAUX WOOD PLANKS. UPDATED FANS AND LIGHTING. PRIMARY BATH HAS FRAMELESS SHOWER DOOR, DOUBLE SINKS, AND HUGE PRIMARY BEDROOM CLOSET. 2\" BLINDS THROUGHOUT, CORNER GAS FIREPLACE IN DEN WITH STONE SURROUND, FRIGIDAIRE SS APPLIANCES ARE NEW INCLUDING MICROWAVE, DISHWASHER, AND 5 BURNER GAS STOVE. ALL KNOBS AND FAUCETS REPLACED WITH BRUSHED NICKEL - ALL CABINETS PAINTED AND HEAVY DUTY BRUSHED STAINLESS PULLS INSTALLED. ALL WALLS FRESHLY PAINTED, RECENT FRONT & REAR FENCE INSTALLED IN HUGE BACK YARD. THIS IS A BEAUTY, HURRY!' ,`Acres` = '0.1634' ,`Area` = '33' ,`BuilderName` = 'TROPHY HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BAY COLONY NORTHPOINTE SEC 1 (2005) ABST 19, BLOCK 3, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7118' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '443' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'BAY COLONY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Colony Northpointe Sec 1' ,`TaxAmount` = '5542' ,`TaxRate` = '2.7847' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418626' WHERE `Matrix_Unique_ID` = '214091890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:11:05.537' ,`MLSNumber` = '80141203' ,`ListAgentFullName` = 'Hong Nguyen' ,`ListOfficeName` = 'Kinh Do Realty' ,`SellingAgentFullName` = 'Hong Nguyen' ,`SellingOfficeName` = 'Kinh Do Realty' ,`Latitude` = '29.580179' ,`Longitude` = '-95.012710' ,`PhotoCount` = '27' ,`PostalCode` = '77586' ,`RoomCount` = '3' ,`ListPrice` = '350000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cottage Cove' ,`StreetNumber` = '1405' ,`StreetSuffix` = 'Court' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2193' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME to a beautiful, well-maintained home located in a quiet, cul-de-sac neighborhood in Seabrook.The kitchen opens up to the breakfast area and living room with a large formal dining room. Featuring many updates throughout the whole house including brand new fences, A/C, roof, paint, carpet and many more. The primary bedroom features a fully renovated bathroom with his/her sinks, walk-in shower with separate oversized tub. It even has a his/her closets! This home is few minutes from the park and the water and very close to Kemah Boardwalk! Schedule your showing today!' ,`Acres` = '0.249' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 7 MYSTIC VILLAGE AT LAKE MIJA' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10846' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mystic Village At Lake Mija' ,`TaxAmount` = '6254' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418627' WHERE `Matrix_Unique_ID` = '214106428' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:12:14.610' ,`MLSNumber` = '41136755' ,`ListAgentFullName` = 'Randy Keisler' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755457' ,`Longitude` = '-95.409785' ,`PhotoCount` = '37' ,`PostalCode` = '77019' ,`RoomCount` = '10' ,`ListPrice` = '1195000.00' ,`Status` = 'Active' ,`StreetName` = 'S Shepherd Drive' ,`StreetNumber` = '1210' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming, fully renovated 4 bedroom, 3 bath home located in sought-after River Oaks neighborhood. This beautiful home was taken down to the studs and thoughtfully and lovingly rebuilt and expanded by 600+ sq feet. Updates include a new expansive kitchen, dining and living area, all new plumbing, electrical, HVAC, windows, custom soft-close cabinets, quartz countertops, kitchen appliances, refinished hardwoods floors throughout, and updated bathrooms. Made for both casual living or formal entertaining, this home has so much to offer. Outside features a 100+ year Live Oak tree, a circular drive, newly installed landscaping, a privacy fence, and sprinkler system. Close proximity to River Oaks Shopping Center, hike-and-bike trails along Allen Parkway, as well as the newly developed Autry Park community, retail shops, and restaurants. Zoned to outstanding schools (River Oaks Elementary, Lanier Middle School, and Lamar High School). Schedule your private showing today!' ,`Acres` = '0.1462' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 50 RIVER OAKS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River Oaks Sec 03' ,`TaxAmount` = '12813' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418627' WHERE `Matrix_Unique_ID` = '214127650' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:44:03.230' ,`MLSNumber` = '43007879' ,`ListAgentFullName` = 'Alma Martinez' ,`ListOfficeName` = 'Rice Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835959' ,`Longitude` = '-95.458727' ,`PhotoCount` = '32' ,`PostalCode` = '77092' ,`RoomCount` = '3' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Verdome' ,`StreetNumber` = '4510' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home! Brand new baths with new plumbing, custom made kitchen cabinets, granite countertops, tile floors in the kitchen plus all new plumbing.The rest of the home comes with the original wood floors, professionally refurbished to maintain that beautiful look. Brand new roof installed in Dec 2021, Brand new HVAC system, New Tankless water heater, Brand new double-wide driveway, New gutters system throughout the house NOT only the front. Never flooded.' ,`Acres` = '0.1653' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 6 OAK FOREST SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 15' ,`TaxAmount` = '5419' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418627' WHERE `Matrix_Unique_ID` = '214153719' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:59:22.403' ,`MLSNumber` = '23440771' ,`ListAgentFullName` = 'Raenette Jones' ,`ListOfficeName` = 'Realty Preferred Lux Door' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769537' ,`Longitude` = '-95.561897' ,`PhotoCount` = '24' ,`PostalCode` = '77024' ,`RoomCount` = '6' ,`ListPrice` = '900000.00' ,`Status` = 'Active' ,`StreetName` = 'Traviata' ,`StreetNumber` = '12814' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Mid Century Marvel located in the prestigious community of Memorial Bend. Fully renovated to bring the true essence back to the timeless style of Mid-Century Modern. Beautiful statement pieces include the black framed pivoting door and a black framed partition door upon entry. Let the sunlight guide you directly to the living space. Natural sunlight from the skylight illuminates the warm and welcoming tone of the home, with Spacious bedrooms for family and guests, and an office space/flex space. The kitchen features beautifully designed finishes with brass accents and custom cabinetry. Also including a new stainless steel gas range, wine fridge, and full-size refrigerator. In the Primary Suite, you will find your ultimate retreat in your open-concept restroom and closet with a custom-designed LED vanity, shower room, and cabinets. Located in the thriving community of Memorial City you are minutes away from the Galleria, Downtown, and highways.' ,`Acres` = '0.2342' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 10 MEMORIAL BEND SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RUMMEL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Memorial Bend Sec 02' ,`TaxAmount` = '10619' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418627' WHERE `Matrix_Unique_ID` = '214203741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:58:39.910' ,`MLSNumber` = '98638478' ,`ListAgentFullName` = 'David Flory' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.090613' ,`Longitude` = '-95.710096' ,`PhotoCount` = '28' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '479900.00' ,`Status` = 'Active' ,`StreetName` = 'Cardinal' ,`StreetNumber` = '22611' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'KITCHEN, BATHROOMS, UTILITY, FLOORING UPDATED 2022! ENCLOSED INDOOR 39x31 SUNROOM CHLORINE FREE POOL. ROOF 2019. Custom Build in Secluded Rosewood Hill! Nestled on a sprawling, 1 acre plus, Wooded Corner Lot. Detached 2 car garage w/workshop, half bath & framed in upper apartment/guest quarters. All Brick Exterior, surrounded by lush trees, boasts attached 2 Car oversized garage and large Craftsman style front porch. Must See: Great split floor plan: High ceilings, both formals, & private office space with shared Austin rock (Dual Sided to Living) Fireplace. Large game/flex room (24 x 14) up (1.5 story). Fabulous island kitchen w/beautiful 52” cabinetry (pots/pans drawers), plentiful prep space & serving bar. Gas range & refrigerator included! Cabinetry/sink in laundry. Relaxing Owner suite: Separate shower, soaking tub w/glass block window. Walk in closet. Community tennis courts, ponds, pavilion, playground & pool. Convenient to local shopping and dining, via Hwy 249.' ,`Acres` = '1.0647' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT E8 ROSEWOOD HILL SEC 6A' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '46378' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '790' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosewood Hill' ,`TaxAmount` = '6549' ,`TaxRate` = '2.1425' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418627' WHERE `Matrix_Unique_ID` = '214421796' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:55:39.797' ,`MLSNumber` = '19781486' ,`ListAgentFullName` = 'Megan Sicking' ,`ListOfficeName` = 'Prime Horizon Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545181' ,`Longitude` = '-95.097245' ,`PhotoCount` = '37' ,`PostalCode` = '77058' ,`RoomCount` = '11' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Saxony' ,`StreetNumber` = '1423' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never flooded and not in flood plain! Fully remodeled, one of a kind home with site-finished oak floors, plantation shutters & designer fixtures throughout. Chef\'s kitchen features floor-to-ceiling custom cabinets w/built-in mixer lift, pot storage, organizers & spice cabinet. Custom pantry w/white oak drawers & built-in microwave. High end appliances- fridge, oversized SMEG gas range/elec. double oven, wine fridge, Bosch dishwasher, high flow filtered pot filler. Quartz island offers ample workspace & bar seating. Dining nook has custom maple farmhouse table & bench seats w/storage. Kitchen opens to family room w/brick fireplace & built-ins. Primary bedroom has his/hers closets, en suite bath w/extra deep soaking tub, custom cabinets & Marakesh tile. 3 spacious bdrms & 1 bath up. Top of the line turf for low-maintenance, green year-round backyard and extended patio. All improvements made with quality & longevity in mind, no detail overlooked. Walking distance to comm. pool & marina.' ,`Acres` = '0.1842' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 4 NASSAU BAY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8024' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '80' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nassau Bay' ,`TaxAmount` = '6109' ,`TaxRate` = '2.5922' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418628' WHERE `Matrix_Unique_ID` = '214432925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:23:07.203' ,`MLSNumber` = '93793527' ,`ListAgentFullName` = 'Alan Stanfield' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472136' ,`Longitude` = '-95.131053' ,`PhotoCount` = '30' ,`PostalCode` = '77573' ,`RoomCount` = '16' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Granite Shadow' ,`StreetNumber` = '2615' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3567' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly extraordinary 5-bedroom home in better-than-new condition boasts a resort-quality backyard oasis that includes a covered patio with an outdoor kitchen & a pristine pool & spa with a tanning ledge, fire feature, extensive travertine decking, & professional landscaping! A brick & stone elevation sets the stage for this Lennar Homes showstopper that features elevated ceilings & staggered porcelain tile floors throughout the dining room, family room with cast stone fireplace, & stunning island kitchen with granite counters, an arabesque tile backsplash, new stainless appliances, & 42\" cabinetry with pull outs & task lighting. Also on the first floor, find a study with French doors & wood floors, a guest suite, a full bath, & a secluded master retreat. A split staircase with iron balusters leads up to a spacious gameroom with French doors, a media room with dimmable sconce lights & surround sound wiring, 3 bedrooms, & 2 baths. Also note the garage with epoxy floors & Onrax storage!' ,`Acres` = '0.1653' ,`Area` = '33' ,`BuilderName` = 'Lennar (Sierra Mesa)' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 BLK 6 MAGNOLIA CREEK SEC 14 (2018) ABST 654 & 660' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '726' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GILMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Crk Sec 14' ,`TaxAmount` = '10998' ,`TaxRate` = '2.2667' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418628' WHERE `Matrix_Unique_ID` = '214482010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:57:40.740' ,`MLSNumber` = '96660596' ,`ListAgentFullName` = 'Earl Trammell' ,`ListOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.612049' ,`Longitude` = '-94.841349' ,`PhotoCount` = '24' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Bird' ,`StreetNumber` = '656' ,`StreetSuffix` = 'Road' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1406' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lake Livingston is minutes away from this 5 acre property ready for all your dreams of living in the country. This beautiful land is spacious enough for your horses, chickens, cows or any other animals and pets of your desire as it’s fully fenced in. The land is 90% cleared and ready to build what ever you can imagine. Perfectly located near freeway and shopping. This is a must see lot and home. Schedule your showing today.' ,`Acres` = '5' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 77 AUGUSTIN VIESCA SURVEY TRACT 301' ,`LotDesciption` = 'Cleared' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'AUGUSTIN VIESCA' ,`TaxAmount` = '1548' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418628' WHERE `Matrix_Unique_ID` = '214509293' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:25:03.420' ,`MLSNumber` = '22640677' ,`ListAgentFullName` = 'Patricia Britt' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.517598' ,`Longitude` = '-95.086586' ,`PhotoCount` = '23' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Halls' ,`StreetNumber` = '1224' ,`StreetSuffix` = 'Bridge' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1288' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great starter Home or prefect for Buyers wanting to down-size. Small subdivision in the Heart of League City, quiet neighborhood. 3 bedrooms with additional bonus room, currently used as 4th bedroom, could be used as a craft room, playroom, or office. New carpet in 2 of the bedrooms. Large Backyard. Refrigerator included. This Home has never flooded. Current Flood Insurance Policy is assumable. Low Tax Rate, Low HOA Fee, CCISD. Make it your Home Sweet Home Today!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HALLS BRIDGE (2004) ABST 3, BLOCK 1, LOT 11, ACRES 0.138' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LEAGUE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Halls Bridge' ,`TaxAmount` = '3977' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418628' WHERE `Matrix_Unique_ID` = '214529015' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:36:53.463' ,`MLSNumber` = '73308764' ,`ListAgentFullName` = 'Kenneth Purswell' ,`ListOfficeName` = 'Kenneth Purswell - Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.086281' ,`Longitude` = '-95.279883' ,`PhotoCount` = '29' ,`PostalCode` = '77541' ,`RoomCount` = '9' ,`ListPrice` = '211400.00' ,`Status` = 'Active' ,`StreetName` = 'Flounder' ,`StreetNumber` = '18' ,`StreetSuffix` = 'Circle' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1148' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1137' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'DEMIJOHN ISLAND SEC 4 (A0157 G M BRYAN) LOT 9' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '4953' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Demijohn Island Sec 4' ,`TaxAmount` = '2786' ,`TaxRate` = '2.3589' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418629' WHERE `Matrix_Unique_ID` = '214560568' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:10:00.440' ,`MLSNumber` = '71940266' ,`ListAgentFullName` = 'Penny Wilson' ,`ListOfficeName` = 'The Wilson Agency II' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815582' ,`Longitude` = '-95.718197' ,`PhotoCount` = '13' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '226400.00' ,`Status` = 'Active' ,`StreetName` = 'Lanville' ,`StreetNumber` = '3106' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 Bedroom 2 1/2 Bath 2264 sq. ft. Two story home on corner lot near Fry Rd. and Morton Rd. The master bedroom is downstairs and has a huge walk-in closet. The master bathroom includes 2 sinks. There is a large living and dining room combo large enough for any family dinners. Also, included is a large den with fireplace near the kitchen. There is a half bath downstairs for family and guests. The large backyard includes a nice patio. The air conditioner is only 1 year old.' ,`Acres` = '0.1646' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 WESTFIELD SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '7168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '373' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCROBERTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield' ,`TaxAmount` = '4925' ,`TaxRate` = '2.387' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418629' WHERE `Matrix_Unique_ID` = '214568808' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:36:25.087' ,`MLSNumber` = '6819047' ,`ListAgentFullName` = 'Tasha Armstead-Bey' ,`ListOfficeName` = 'CR Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984473' ,`Longitude` = '-95.518940' ,`PhotoCount` = '4' ,`PostalCode` = '77069' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Wanakah' ,`StreetNumber` = '5703' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome HOME! This beautiful 4-bedroom home is located in the highly desirable Champions community on a corner lot and is equipped with 2.5 baths. It has a formal living room, dining room, and a family room which is open to breakfast and kitchen areas. The family room has clear views of the oversized backyard of your dreams! Detached 2-car garage. The primary bedroom is located on the first floor. The primary ensuite has double sinks and tons of room and opportunity. Three bedrooms upstairs with access to a full bathroom with double sinks. This house is a must-see and will not last long!! This is just the Home you and your family want for the Holidays!!' ,`Acres` = '0.2686' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 131 BLK 8 CHAMPIONS EAST U/R & PAR R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champion East Unr Pt & Rp' ,`TaxAmount` = '5673' ,`TaxRate` = '2.4906' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418629' WHERE `Matrix_Unique_ID` = '214607291' --> 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','214631784','1668418629','214631784','2022-11-13T08:42:45.450','15951446','Tracy Prohoniak Stacey','Keller Williams Realty - Clear Lake/ NASA','','','29.496253','-94.990441','17','77518','5','165000.00','Active','Caranchua Reef','4810','Drive','Bacliff','2','0','3','1096','Single-Family','Lovely 3 bedroom 2 bath home in Bacliff Villas. This home features tile floors throughout, kitchen open to main living area, built-in storage, and a large backyard with covered patio. Brand new oven/stove. Easy access from Hwy 146 to schools, shopping, and restaurants. Come and see it!','0.1148','33','','','','','Mud,Sellers Disclosure','1','','0','Bacliff/San Leon','Central Gas','0','ABST 88 A HATCH SUR LOT 20 BLK 4 BACLIFF VILLAS SEC 2','Subdivision Lot','5000','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Cooktop','','Composition','17 - Dickinson','KENNETH E. LITTLE ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','DUNBAR MIDDLE SCHOOL (DICKINSON)','Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Bacliff Villas','3115','2.2342','Water District','1978','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T07:35:38.897' ,`MLSNumber` = '85630307' ,`ListAgentFullName` = 'Lorna Ramsay' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728430' ,`Longitude` = '-95.765015' ,`PhotoCount` = '49' ,`PostalCode` = '77450' ,`RoomCount` = '12' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Maily Meadow' ,`StreetNumber` = '4211' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very well maintained & updated David Weekly 4 or 5 bedroom, 3/1 bath, game room, media room, 3 car tandem garage with off street parking, large screened back patio with slate floor, large yard with enough space for a pool. Enter into this beautiful home to a double height entry, open Dining Room with chandelier recently refinished hard wood floors, large study to the front of the home with glass doors for privacy if working from home, curved staircase, double art niches, crown molding throughout. Enjoy open plan living through to the living room, dining room & breakfast room, granite counters, new electric cook top, living room has high ceiling, gas fireplace & built in book cases. Bathrooms have new oil rubbed bronze faucets & fittings, new light fittings & ceiling fans throughout, New door handles & knobs throughout. This home has mature landscapes yards & sprinkler system. Zoned to Exemplary Katy ISD Schools - Walk to nearby Williams Elementary School.' ,`Acres` = '0.2168' ,`Area` = '36' ,`BuilderName` = 'David Weekly' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH CINCO FOREST SEC 1, BLOCK 2, LOT 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9445' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch Cinco Forest' ,`TaxAmount` = '10402' ,`TaxRate` = '2.4395' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418629' WHERE `Matrix_Unique_ID` = '214636196' --> 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','214647841','1668418630','214647841','2022-11-13T07:43:09.223','63233082','Danny Vu','Danny Vu Realty','','','29.907672','-95.313258','13','77039','8','199900.00','Active','Sandydale','5223','Lane','Houston','3','0','4','1900','Single-Family','Beautiful large brick home in a great neighborhood, with 4 bedrooms (2 primary) and 3 full baths, large formal living room could be 5 bedroom or media room, huge kitchen with granite countertops, SS appliances, 6 yrs old roof and furnace, fully fenced backyard with no back neighbor. Minutes from downtown, Bush Airport, Dearbrook Mall, Hwy 59, and BW8. Come see it today before it\'s gone tomorrow.','0.1818','34','','','','','Sellers Disclosure','','','','Aldine Area','Central Gas','0','LT 210 BLK 2 FAIRGREEN SEC 2','Cleared','7920','Appraisal District','','','0','','2','','0','','','','','Composition','1 - Aldine','OLESON ELEMENTARY SCHOOL','MACARTHUR HIGH SCHOOL (ALDINE)','MEAD MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Fairgreen Sec 02','4452','2.9881','Public Sewer,Public Water,Water District','1968','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:28:09.053' ,`MLSNumber` = '68171923' ,`ListAgentFullName` = 'Venessa James' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727094' ,`Longitude` = '-95.868463' ,`PhotoCount` = '45' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '469900.00' ,`Status` = 'Active' ,`StreetName` = 'Prairie Landing' ,`StreetNumber` = '4215' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3330' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new! Beautiful DR Horton Henderson floorplan which boasts over 3300 of living space, 4 bedrooms, 3.5 bathrooms a gameroom and a media room! Enjoy the formal dining room, which can also be used as an office in the front entrance of the home. \r\nThe open concept and high ceilings make this home inviting and entertaining. The primary bedroom is located on the first floor and it features a separate soaker tub and shower, dual vanities and a spacious walk-in closet! The secondary bedrooms are spacious with walk-in closets. Enjoy the jack and jill bedrooms upstairs. Live the lifestyle in Tamarron with the community resort pool, splashpad, fitness center, sports fields, lakes & walking trails. Zones to Katy ISD. You do not want to miss an opportunity to own this home that has no back neighbors and a covered rear patio. Schedule a tour today to view all that this home has to offer!' ,`Acres` = '0.1805' ,`Area` = '36' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 31, BLOCK 1, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7861' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron Sec' ,`TaxAmount` = '11464' ,`TaxRate` = '3.3775' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668418630' WHERE `Matrix_Unique_ID` = '214672278' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:46:21.443' ,`MLSNumber` = '76161537' ,`ListAgentFullName` = 'Cherri Thomas' ,`ListOfficeName` = 'Pine Forest Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.881650' ,`Longitude` = '-95.460816' ,`PhotoCount` = '13' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'High Mountain' ,`StreetNumber` = '8818' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1581' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to a quiet neighborhood with wide tree lined streets, curbs, and sidewalks. This sun filled, 4 bedroom, 2 1/2 bath home on a corner lot has tile flooring through out and laundry on the second floor.\r\n\r\nThis home has great potential with some TLC for growing families. It is close to community center and schools and centrally located near I-45, I-249, and Beltway 8.' ,`Acres` = '0.1391' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 8 INWOOD FOREST VILLAGE' ,`LotDesciption` = 'Corner' ,`LotSize` = '6060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARAWAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Forest Village' ,`TaxAmount` = '2889' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418630' WHERE `Matrix_Unique_ID` = '214688633' --> 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','214697558','1668418630','214697558','2022-11-13T08:22:32.290','10620953','Chunli Yu','REALM Real Estate Professional','','','30.082632','-95.400407','23','77373','8','285900.00','Active','Lexington Park','2711','Drive','Spring','3','0','4','2119','Single-Family','Rare floor plan. Double master bedrooms each with garden tubs/separate showers. 4 bedrooms,3 full baths. All bedrooms have ceiling fans. Secondary bathroom is very spacious. Tile floor in all areas except bedrooms. New laminate floor on all bedrooms. Front porch with ceiling fan. Spacious family room, french doors open to the flagstone covered patio with ceiling fan. Spacious kitchen with stainless steel appliances, 42 inch cabinets. Utilities room with upper cabinets. Exterior walls are all bricks,No back neighbor, front and back gutter, backyard toward woods. Storage shed included.','0.1378','12','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Spring East','Central Gas','1','LT 15 BLK 2 LEXINGTON PARK SEC 1','Subdivision Lot','6003','Appraisal District','','395','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','48 - Spring','JOHN WINSHIP ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','TWIN CREEKS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','Lexington Park','4535','2.2769','Public Sewer,Public Water,Water District','2010','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T08:49:28.107' ,`MLSNumber` = '74965740' ,`ListAgentFullName` = 'Christian Mendoza' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514843' ,`Longitude` = '-95.006992' ,`PhotoCount` = '2' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Trocadero' ,`StreetNumber` = '2416' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom 3 full bath home that is perfectly situated on a cul-de-sac lot, in the desirable neighborhood of Marbella, which is zoned to CCISD schools! This home offers everything needed for a family to thrive. Home boast a 30’ wide custom backyard covered patio, equipped with canned lighting and exterior fans. In addition, the interior of the home boasts, an open concept design, a private flex/office, laundry room that is on the 1st floor and a large game room that is located upstairs. This home includes several upgrades from the wood grain tiled flooring, to custom light fixtures, granite countertops, tiled bathrooms, fresh paint on the walls and much more. Come and check out this gem and make it yours, before it is gone!' ,`Acres` = '0.1838' ,`Area` = '33' ,`BuilderName` = 'Castlerock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MAR BELLA SEC 15-A & B (2016) ABST 32 & 67, BLOCK 2, LOT 29,' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8006' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1015' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mar Bella Sec 15-A & B A' ,`TaxAmount` = '12125' ,`TaxRate` = '2.7997' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668418630' WHERE `Matrix_Unique_ID` = '214697562' --> 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','214702365','1668418630','214702365','2022-11-13T07:13:39.953','13408532','Kevin Starr','Coldwell Banker Realty, Cy-Fair Office','','','29.912751','-95.669773','43','77095','11','325000.00','Active','Curry Landing','9426','Drive','Houston','2','1','4','2402','Single-Family','Beautiful home set in Canyon Lakes at Stonegate comes with lots of amenities: pools, splash pad, lakes, tennis court, basketball court, sand volleyball, workout room, and the Houston National Golf Club. Terrific floor plan with formal dining room, primary bedroom downstairs, game room and three bedrooms up. You will enjoy gas cooking in this beautiful kitchen with lots of counter space, and a breakfast bar. Refrigerator, washer, and dryer included. Primary suite has large separate shower and jetted tub. 2\'\' blinds throughout. Huge backyard with front and back sprinkler system. Highly rated Cy Fair School District. This home has never flooded. Don’t miss the 3D Virtual Tour.','','8','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Copperfield Area','Central Gas','1','LT 56 BLK 2 CANYON LAKES AT STONEGATE SEC 11','In Golf Course Community','6111','Appraisal District','','940','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','BIRKES ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','ARAGON MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Canyon Lks/Stonegate','','','Water District','2007','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','214702745','1668418630','214702745','2022-11-13T08:54:25.700','13676190','Christina Morehouse','Vive Realty LLC','','','30.365480','-94.789970','43','77327','7','130000.00','Active','County Road 2122a','95','','Cleveland','1','0','2','600','Single-Family','Welcome to the desired Trinity River and Lake Estates subdivision, this lake house has 2 bedrooms and 1 full bath in the main house and a shed that was converted into a cabin-like style with bunk beds and a mini-split for AC & heating. The lake house has its own access to the Old River Lake, this is a private lake for residents only. The lake house sits on a nice spacious lot between Old River Lake and the George Ruby Bend. The house has many upgrades from the kitchen cabinets to the waterproof flooring, recess lighting inside and outside, new plumbing piping in the main bathroom. What you see is what you get with this one, everything you see on the photos stay with the property. Call today for your private showing.','0.2314','52','','','','','Sellers Disclosure','0','','','Liberty County East','Propane,Window Unit','0','TRINITY RIVER & LAKE ESTATES, BLOCK 25, LOT 63 64, ACRES .23','Corner,Water View,Waterfront','10080','Appraisal District','','','0','','0','Freestanding Oven','0','','','Gas Range','','Composition','107 - Hardin','HARDIN ELEMENTARY SCHOOL','HARDIN HIGH SCHOOL','','Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Trinity River & Lake Estates','834','1.7656','Other Water/Sewer','1970','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','214702791','1668418630','214702791','2022-11-13T08:30:52.803','80486683','Zhaoqi Li','Agent Realty','','','29.942993','-95.174429','38','77044','8','588000.00','Active','Easton Gate','15406','Lane','Houston','6','1','6','4973','Single-Family','Wow, this stunning 6 bedroom 6.5 bathroom house offers 4973 sqft of living. Located in a gated community, in the beautiful neighborhood of Lakewood Pines. It features open floor plan. Big windows let in plenty of natural light. Common area of first floor has luxury hardwood floor. Kitchen boast beautiful white cabinetry, granite countertops, and stainless steel appliances. On the first floor, you will find spacious living area, and a formal dinning area. Large backyard with cover patio, great for entertaining. The primary suite is very spacious, there is enough space for adding a reading area by the huge windows. The primary bathroom offers dual sinks, separate shower and tub. Did I mention this home has 5 additional bedrooms, and total of 6.5 bathrooms, call to schedule your showings, and make this your dream home!','0.2078','1','','','','','No Disclosures','','','1','Summerwood/Lakeshore','Central Gas','1','LT 11 BLK 2 LAKEWOOD PINES SEC 3','Cul-De-Sac','9053','Appraisal District','','800','0','','2','','0','','','','','Composition','29 - Humble','CENTENNIAL ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','AUTUMN RIDGE MIDDLE SCHOOL','Call Occupant','Appraisal District','2','Traditional','Lakewood Pines','','','Public Sewer,Public Water,Water District','2016','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','214702888','1668418630','214702888','2022-11-13T08:58:36.400','24400853','Derek Boles','Legacy Homes & Properties, LLC','','','29.649362','-95.484571','33','77035','4','310000.00','Active','Renwick','11914','Drive','Houston','2','0','4','1659','Single-Family','**NEW PRICE** - Stop the Car! Finally a home that has it all. This gem is nestled in a great community near local freeways on a exclusive large cul-de-sac lot. No neighbors on both sides, great for additional entertaining space. Well maintained yard as you approach this fully renovated home. New front door, new interior and exterior paint, new flooring and brand new custom kitchen. The study/bedroom off to the right is perfect for working/studying/sleeping. Large open floorplan from living room to kitchen. The primary retreat is a great size and comes with a brand new restroom with double vanity and large shower! There are too many upgrades to list. But you will love at first sight. See you soon!','0.2557','20','','','','','Sellers Disclosure','','','','Brays Oaks','Central Gas','0','LT 17 BLK 110 WESTBURY SEC 4','Subdivision Lot','11140','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','ANDERSON ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Westbury Sec 04','2314','2.3307','Public Sewer,Public Water','1958','Appraisal District'); --> New record created successfully