Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:27:32.793' ,`MLSNumber` = '4900149' ,`ListAgentFullName` = 'Jana Bruce' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753209' ,`Longitude` = '-95.522656' ,`PhotoCount` = '50' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '4475000.00' ,`Status` = 'Active' ,`StreetName` = 'Blalock' ,`StreetNumber` = '230' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '8023' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Expertly reconstructed Piney Point showcase home on over an acre and built with uncompromising quality rivaling the finest new construction. Turn-key interior is defined by grand proportions notably the magnificent living room that blends seamlessly with the kitchen, dining and wet bar. Professionally-equipped kitchen features a central island with seating, a walk-in pantry, and Thermador appliances including a gas range, double ovens, refrigerator, freezer, speed oven, and built-in coffee maker. The first floor primary suite offers a quiet retreat with a fireplace, sitting room, coffee bar, shared walk-in closet, laundry and bathroom featuring double vanities, heated floor and a double shower and soaking tub. Back stairs lead to a bedroom suite, kitchenette, media room and flex room. The expansive circular drive approaches the porte-cochere and front entry with steel pivot door, and the back yard features one of the largest pools in the Villages complete with water features and a spa.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 Dullien' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '46187' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Dullien' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227174' WHERE `Matrix_Unique_ID` = '206773286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:45:55.080' ,`MLSNumber` = '46803094' ,`ListAgentFullName` = 'Michelle Soderberg' ,`ListOfficeName` = 'Michelle Mathenia Soderberg' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.290164' ,`Longitude` = '-95.555514' ,`PhotoCount` = '16' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Aster View' ,`StreetNumber` = '230' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1615' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great, open floor plan, 1 story with lots of extras. The garage has epoxy floors with a wash sink. The backyard has an extended porch with an area for a firepit. Even has a gas hook-up for your grill. HUGE kitchen island for entertaining. All room dimensions should be independently verified.' ,`Acres` = '0.1658' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965275 - WOODFOREST 75, BLOCK 1, LOT 43' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7222' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 75' ,`TaxAmount` = '7200' ,`TaxRate` = '2.8388' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667227175' WHERE `Matrix_Unique_ID` = '207885089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:30:53.687' ,`MLSNumber` = '69039546' ,`ListAgentFullName` = 'Morgan Duran' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.746675' ,`Longitude` = '-95.588924' ,`PhotoCount` = '20' ,`PostalCode` = '77077' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Spruce Hill' ,`StreetNumber` = '11806' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2241' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own on this huge cul-de-sac lot, FULLY RENOVATED! With 4 bedrooms and 2 bathrooms and vaulted ceilings throughout. Brand new waterproof flooring paired with the beautiful original Spanish tile. All electrical and plumbing (PEX) updated. Fresh paint throughout the whole interior. Full kitchen update with all new shaker cabinets, gas range with potfiller and stainless steel appliances. Full foundation repair that comes with a transferable lifetime warranty. Brand new 4-ton Carrier AC system. Brand new tankless water heater. This home is ready for your family for many years to come!' ,`Acres` = '0.2582' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 14A BLK 16 ASHFORD VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11247' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Ashford Village Sec 02' ,`TaxAmount` = '7046' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667227175' WHERE `Matrix_Unique_ID` = '209361718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:13:58.627' ,`MLSNumber` = '98006216' ,`ListAgentFullName` = 'Faheem Ghaffar' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763182' ,`Longitude` = '-95.607272' ,`PhotoCount` = '50' ,`PostalCode` = '77079' ,`RoomCount` = '1' ,`ListPrice` = '729900.00' ,`Status` = 'Active' ,`StreetName` = 'Bramblewood' ,`StreetNumber` = '14614' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3151' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come Home to this Meticulously Upgraded and Well Maintained 4 Bed 2.5 Bath One Story House in the Prestigeous Westchester Subdivision. Kitchen Offers Custom Cabinets & Quartz Countertops, Coffee bar & More. Master Bath has Double Sink Vanities, Quartz Counters, Bubbling Spa Tub and a Double Shower. The Beautiful Backyard has a Private Pool, Covered Patio and a Complete Outdoor Kitchen to relax and enjoy your evenings and weekends. \r\nHouse does offer a Long, Gated Driveway with a Detached Garage. Zoned to Highly Rated SBISD schools and conveniently located near the Energy Corridor and many amenities.' ,`Acres` = '0.2057' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 7 WESTCHESTER SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'NOTTINGHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westchester Sec 01' ,`TaxAmount` = '15208' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227175' WHERE `Matrix_Unique_ID` = '210063127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:38:43.650' ,`MLSNumber` = '13993508' ,`ListAgentFullName` = 'Brandon Warren' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.718904' ,`Longitude` = '-95.587431' ,`PhotoCount` = '42' ,`PostalCode` = '77082' ,`RoomCount` = '9' ,`ListPrice` = '1069000.00' ,`Status` = 'Active' ,`StreetName` = 'Louvre' ,`StreetNumber` = '11910' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL Custom home on a sprawling corner cul-de-sac lot! Welcome home thru the double iron front doors, sweeping 2 story foyer with stunning iron stairway, formal living and dining areas, neutral colors, marble inlaid floors, natural light, cove lighting in the formal spaces, custom wall treatments, plantation shutters, spacious Chefs kitchen with granite countertops, abundance of prep & storage space, walk in pantry, breakfast bar, dry bar w/ wine storage, surround sound, expansive primary retreat at 2nd floor with sitting area & coffee bar, incredible bath retreat with dual vanities, generous storage & dressing space,game/media rm (currently used as an office), spacious guest rooms, whole house water filtration system, large backyard with endless design options-great for pets, a pool or a play area if desired, inviting covered patio w/ electric sun shade, beautiful landscape,3 car garage,whole home water filtration system, rare cul-de-sac lot in ROCC!' ,`Acres` = '0.2775' ,`Area` = '31' ,`BuilderName` = 'Vanguard Custom Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 13' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '12086' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Royal Oaks Country Club' ,`TaxAmount` = '22020' ,`TaxRate` = '2.6086' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227175' WHERE `Matrix_Unique_ID` = '210813468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:23:41.290' ,`MLSNumber` = '86118673' ,`ListAgentFullName` = 'Lacy Patterson' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.082898' ,`Longitude` = '-94.801733' ,`PhotoCount` = '42' ,`PostalCode` = '77575' ,`RoomCount` = '10' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeside' ,`StreetNumber` = '6011' ,`StreetSuffix` = 'Drive' ,`City` = 'Liberty' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2749' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6011 Lakeside Dr located in Travis Park, waterfront to private lake! The property has alot to offer all within the city limits on private 24 arce lake stocked for fishing from dock or non motorboat. As you entry this beautiful home you are greeted with french stained doors that lead you onto the white mexican style tile. Coming into the sunkin living room that offers soaring ceiling, gas log fireplace and breathe taking views on the paradise that awaits you outside. The master is steps from the living room with large sliding doors that takes you onto the patio to enjoy your morning coffee and take in the deer and birds forgetting that you are in town. Masterbath offers heated jetted tub, heated tile floors and towel warming rack, separate tiled shower, large walk-in closet. You will be ready to entertain with the outdoor space, large covered patio, approx. 984 sqft gunite pool with hot tub, additional office, pool house, workshop, outdoor kitchen. 2-1 RATE BUY DOWN OFFERED.' ,`Acres` = '0.5676' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRAVIS PARK, LOT 10-A, PT 11, SEC 1, ACRES .5676' ,`LotDesciption` = 'Cleared' ,`LotSize` = '24725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Travis Park' ,`TaxAmount` = '9973' ,`TaxRate` = '2.6826' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667227175' WHERE `Matrix_Unique_ID` = '211132660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:46:25.550' ,`MLSNumber` = '10830846' ,`ListAgentFullName` = 'Bruce Scott' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075272' ,`Longitude` = '-95.456797' ,`PhotoCount` = '32' ,`PostalCode` = '77388' ,`RoomCount` = '8' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Daneswood' ,`StreetNumber` = '2438' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1939' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love with this move in ready one-story home, conveniently located close to I45, the Hardy Toll Road, Grand Parkway and Highway 249. This quality home features 4-sides brick and is nestled in a cul-de-sac on a large lot. Enjoy your evenings on the large deck in the back yard. Many of the systems in the home have been recently replaced. Roof, garage door motor, water heater, range and all blinds replaced 2018. The heating system was replaced in 2021. The evaporator coil was replaced in 2022, as well as all cabinets and sinks and new interior and exterior paint. Welcome to YOUR new home!' ,`Acres` = '0.2502' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 5 HANNOVER ESTATES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KREINHOP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hannover Estates Sec 01' ,`TaxAmount` = '5509' ,`TaxRate` = '2.854' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227176' WHERE `Matrix_Unique_ID` = '211679384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:46:15.827' ,`MLSNumber` = '73155216' ,`ListAgentFullName` = 'Christine Shepherd' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.133013' ,`Longitude` = '-94.900450' ,`PhotoCount` = '33' ,`PostalCode` = '77535' ,`RoomCount` = '3' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 6501' ,`StreetNumber` = '748' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1966' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Farmhouse style home! This home has all the farmhouse features. Shiplap, galvanized metal wainscoting, wood trim and wood look flooring! Just bring your decorating ideas and make it your own. Open concept home offers two living spaces. Family room and separate game room. Family will enjoy the huge game room with vaulted ceiling. Custom, soft close cabinets and granite make the kitchen a standout. Kitchen is open to the family and dining areas. All new stainless appliances. Covered patio will be perfect for relaxing or entertaining. Above ground pool will be enjoyed on hot summer days. Garage is oversized with 10\' rollup doors and attached carport. No HOA so horses or Ag projects are welcome. There is a chicken coop and small storage/workshop. Owners have done all the work. Make an appointment to see this home today.' ,`Acres` = '1.99' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SPUR FOREST, LOT 31 (E/PT), SEC 1, ACRES 1.99' ,`LotDesciption` = 'Cleared' ,`LotSize` = '86684' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Spur Forest' ,`TaxAmount` = '4646' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227176' WHERE `Matrix_Unique_ID` = '211742601' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:34:24.820' ,`MLSNumber` = '43385195' ,`ListAgentFullName` = 'Brandi Paullo' ,`ListOfficeName` = 'The Taylor Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806079' ,`Longitude` = '-95.575163' ,`PhotoCount` = '33' ,`PostalCode` = '77043' ,`RoomCount` = '5' ,`ListPrice` = '374990.00' ,`Status` = 'Active' ,`StreetName` = 'Sherwood Forest' ,`StreetNumber` = '2067' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1876' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new! This fabulous 2019 built 3 bedroom 3.5 bath patio home with attached 2 car garage has it all! The lightly lived in fresh modern interior features high ceilings, engineered wood floors, private gated front yard, plantation shutters, open floor plan and more. Open island kitchen with white cabinetry, custom backsplash, apron sink, quartz counter tops, and stainless appliances. Large living room and open dining space, add to the appeal of the downstair with lots of natural light. Master boasts walk-in closet, double sinks, soaking tub, and oversized shower. Both secondary bedrooms with private bathrooms, generous closets and high ceilings. The open floorplan is perfect for entertaining and there is ample street parking. Easy access to BW8, I-10, City Centre, Energy Corridor, and Memorial City. Schedule your private showing today!' ,`Acres` = '0.0464' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 BEYOND METRONOME' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Beyond Metronome' ,`TaxAmount` = '8243' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227176' WHERE `Matrix_Unique_ID` = '211892088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:32:03.997' ,`MLSNumber` = '86710996' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Silvia Cantu' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.734306' ,`Longitude` = '-95.865551' ,`PhotoCount` = '48' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '524990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Freemans View' ,`StreetNumber` = '28510' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to KATY ISD ZONED! D.R. Horton\'s Rockdale Floorplan on a HUGE Cul-Du-Sac Lot! ATTACHMENTS SHOW COLOR PACKAGE. \"Smart Home\" all controllable through your Hub or smartphone. Gorgeous Kitchen with Silestone counters and 42\" Cabinets! There is a secondary bedroom wing for the kiddos with a study nook. Large covered patio, ready for week-end BBQ\'s with plumed gas! Included is everything you are looking for in a family friendly community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails ready for you! Call today for your own private tour! Please verify with sales agent options and any upgrades. **PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY***At this time builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 139; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14418' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single 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,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667227176' WHERE `Matrix_Unique_ID` = '211956055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:07:02.637' ,`MLSNumber` = '44931770' ,`ListAgentFullName` = 'Stacie Fontenot' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = 'Lucia Martinez' ,`SellingOfficeName` = 'Greystone Realty, LLC' ,`Latitude` = '28.988867' ,`Longitude` = '-95.947192' ,`PhotoCount` = '29' ,`PostalCode` = '77414' ,`RoomCount` = '7' ,`ListPrice` = '285900.00' ,`Status` = 'Option Pending' ,`StreetName` = '12th' ,`StreetNumber` = '3400' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is a must see!!!!!! With over 1800 sq.ft 3 bedrooms and 2 bathrooms, a bonus room that can be used as a formal dining, office or playroom, its perfect. And only 25 minutes from the beach summers will be a blast. Being move in ready with all appliances including refrigerator, Washer and dryer, you can be in this home and ready to decorate for Thanksgiving. Call today for your private showing.' ,`Acres` = '0.3329' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LIVE OAK ESTATES SEC 1, BLOCK 2, LOT 15' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '14499' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Live Oak Estates Sec 1' ,`TaxAmount` = '5907' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667227176' WHERE `Matrix_Unique_ID` = '212393820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:37:32.390' ,`MLSNumber` = '52805060' ,`ListAgentFullName` = 'Sandra Serrano' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.395981' ,`Longitude` = '-95.317339' ,`PhotoCount` = '49' ,`PostalCode` = '77511' ,`RoomCount` = '4' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Lea' ,`StreetNumber` = '12815' ,`StreetSuffix` = 'Lane' ,`City` = 'Alvin' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! Barndominium home on an acre with plenty of privacy to feel like you\'re away from the city \r\n2 Separate living units. \r\nGreat income producing property while you live here!\r\n1st Unit downstairs features open concept kitchen/living/dining area with Primary bedroom with bath suite and grand garage for parties or a workspace.\r\n2nd Unit is upstairs with its own private entrance features 3 bd/2 full bath and a large quartz island in kitchen and living room area.\r\nEnjoy your morning coffee under the wrap around covered porch while enjoying the scenery.\r\nNew temp glass windows\r\nHurricane grade garage doors\r\nPex Plumbing\r\nLow Maintenace roof & siding \r\nNew septic\r\nNew well \r\nMobile home stays on the property and is used as a rental as well\r\nAlvin Community College, shopping, eatery close by.' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRY LEA (A0411 A C H & B) LOT 7-8-9' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Barndominium' ,`Subdivision` = 'Country Lea' ,`TaxAmount` = '3974' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227177' WHERE `Matrix_Unique_ID` = '212434664' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:56:53.123' ,`MLSNumber` = '87550554' ,`ListAgentFullName` = 'Maria Mercado' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.017126' ,`Longitude` = '-93.815705' ,`PhotoCount` = '18' ,`PostalCode` = '77611' ,`RoomCount` = '3' ,`ListPrice` = '80000.00' ,`Status` = 'Active' ,`StreetName` = 'Norbert' ,`StreetNumber` = '1080' ,`StreetSuffix` = 'Street' ,`City` = 'Orange' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for an investment property to buy, you found it! Come and take a look at this property. It offers over 1.2 acres of land. Some is cleared and some is not. Lots of trees around and plenty of shade. House has 3 bedrooms and 1 bath. House needs some work and work has already been started. House is near Sabine Lake. House sits on a corner! Call your Real Estate Agent and make an appointment to see it.' ,`Acres` = '1.212' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 30 & 31, TR 2,& PT OF TR 4 BLK 6 DUGAS #3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '52795' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Dugas # 1 - 6' ,`TaxAmount` = '2072' ,`TaxRate` = '2.3141' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227177' WHERE `Matrix_Unique_ID` = '212482164' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:45:14.410' ,`MLSNumber` = '67745372' ,`ListAgentFullName` = 'Haley Johnson' ,`ListOfficeName` = 'Tejas Land Co.' ,`SellingAgentFullName` = 'Felipe Padilla' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.158359' ,`Longitude` = '-95.501658' ,`PhotoCount` = '42' ,`PostalCode` = '77381' ,`RoomCount` = '9' ,`ListPrice` = '295000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Woodstock Circle' ,`StreetNumber` = '22' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME! This 3 bedroom, 2 bathroom home in the sought-after Panther\'s Creek subdivision is conveniently located in the heart of The Woodlands. It is within walking/biking distance of shopping, dining, parks, pools, and schools. This well-maintained single-story home features updated electricity, lighting, tile flooring throughout, freshly painted walls, and newly installed kitchen cabinets. The fenced-in backyard is large enough for all types of entertaining or a pool. It is a MUST-see, book your appointment today!' ,`Acres` = '0.1603' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL PANTHER CK 02, BLOCK 2, LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6982' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GLEN LOCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Wdlnds Village Panther Ck 02' ,`TaxAmount` = '3319' ,`TaxRate` = '2.0869' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227177' WHERE `Matrix_Unique_ID` = '212486102' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:01:56.247' ,`MLSNumber` = '49061280' ,`ListAgentFullName` = 'Angela Angers' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = 'Jose Hidalgo' ,`SellingOfficeName` = 'Texas Ally Real Estate Group,' ,`Latitude` = '29.986827' ,`Longitude` = '-95.185038' ,`PhotoCount` = '49' ,`PostalCode` = '77346' ,`RoomCount` = '12' ,`ListPrice` = '465000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Brazos Bend' ,`StreetNumber` = '12615' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS IS THE HOME! Almost everything on this home has been remodeled or replaced! 5 Bedroom home on cul-de-sac that sets on one of the largest lots in Eagle Springs! Over 1/4 of an acre lot with a storage building that sets behind the oversized 3 car garage. Interior boast new paint, new wood flooring, and new carpet. All fixtures, ceiling fans, hardware, and light fixtures have been replaced. The home has had roof replaced in 2018, AC/Furnace replaced with Trane unit in 2018 with a 10-year transferable warranty. Home also has all new windows throughout. Windows have a lifetime transferable warranty. The living area has gas log fireplace and is surrounded by built ins. There is also built ins upstairs as well. One of the upstairs 5th bedroom was previously used by seller as media room . Fantastic floor plan with tons of windows and high ceilings.' ,`Acres` = '0.2529' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 4 EAGLE SPRINGS SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11018' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'EAGLE SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '9539' ,`TaxRate` = '2.9726' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227177' WHERE `Matrix_Unique_ID` = '212628606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:08:58.543' ,`MLSNumber` = '3249057' ,`ListAgentFullName` = 'Rose Scharning' ,`ListOfficeName` = 'Boulevard Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792845' ,`Longitude` = '-95.405423' ,`PhotoCount` = '45' ,`PostalCode` = '77008' ,`RoomCount` = '11' ,`ListPrice` = '1599000.00' ,`Status` = 'Active' ,`StreetName` = 'Nicholson' ,`StreetNumber` = '1211' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern Farm House Living at 1211 Nicholson. Just completed by Ansari Homes. Located in the Heart of the Heights. The home offers high quality millwork & craftsmanship built on sight. 11 ft ceilings w/ crown molding, White oak hardwood floors, generous storage throughout the house. Tasteful finishes, high end lighting and fans. Well appointed Kitchen w/subway tile, Thermador Appliances, Pot Filler, and Quartzite Countertops. Butler\'s panty includes a Wine Chiller and Ice Maker, Walkin Panty, Study, Full Bath, and a Mudroom. 4 Bedrooms upstairs 3 Baths, Spacious Primary Suite is nice and roomy, Luxurious Primary Bath offers porcelain countertops, double sinks, stand alone tub, frameless shower w/ beautiful tile, and a fabulous closet. Plus 500 Sq Ft 1 bedroom Garage Apt with the same features as the house. High Energy Features, LED lighting, Insulation, Tankless Water Heater. Close to Love park, LORO and the MKT.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Ansari Homes Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 179 HOUSTON HEIGHTS 77TH AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '7999' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667227178' WHERE `Matrix_Unique_ID` = '212681428' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:52:04.043' ,`MLSNumber` = '96744974' ,`ListAgentFullName` = 'James Phillips' ,`ListOfficeName` = 'Phillips & Sons Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648542' ,`Longitude` = '-95.586809' ,`PhotoCount` = '19' ,`PostalCode` = '77477' ,`RoomCount` = '8' ,`ListPrice` = '393000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Crest' ,`StreetNumber` = '11930' ,`StreetSuffix` = 'Drive' ,`City` = 'Meadows Place' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RECENTLY REMODELED, NEW ROOF, GRANITE COUNTER TOPS' ,`Acres` = '0.1225' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MEADOWGLEN SEC 1, BLOCK 4, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MEADOWS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Meadowglen Sec 1' ,`TaxAmount` = '5719' ,`TaxRate` = '2.4949' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227178' WHERE `Matrix_Unique_ID` = '212703697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:54:49.887' ,`MLSNumber` = '30546976' ,`ListAgentFullName` = 'Marina Okorocha' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.808526' ,`Longitude` = '-95.583164' ,`PhotoCount` = '22' ,`PostalCode` = '77320' ,`RoomCount` = '11' ,`ListPrice` = '186900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue F' ,`StreetNumber` = '701' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hidden Treasure is less than Minutes away from I-45, and Sam Houston University. \r\nNatural lighting, all Brick Home has plush white carpet in oversized bedrooms; ready to be styled and decorated; humongous bathrooms with vanity. Not to mention there are Skylights throughout the home!\r\nTake a walk to the historic downtown loaded with family fun and festivities for the seasons!\r\nThe property Depicts mature oak and pine trees in a peaceful neighborhood. Relax under the covered patio porch and covered car parking spaces. This nice-sized home sits on half an acre of land.\r\nDon’t miss out on this Gem of an opportunity to own your own Country Oasis.\r\n\r\n\r\nPriced to sell, under appraised value. As-Is.' ,`Acres` = '0.5422' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WOODLAWN, LOT 34, 35, 36, 37' ,`LotDesciption` = 'Corner' ,`LotSize` = '23618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Lockbox Left Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'WOODLAWN' ,`TaxAmount` = '3799' ,`TaxRate` = '1.901719' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227178' WHERE `Matrix_Unique_ID` = '212924157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:52:07.773' ,`MLSNumber` = '23625151' ,`ListAgentFullName` = 'Sam Sharif' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.060026' ,`Longitude` = '-95.732476' ,`PhotoCount` = '35' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '749999.00' ,`Status` = 'Active' ,`StreetName` = 'Stone Lake' ,`StreetNumber` = '20317' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3115' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning two story 4 bed, 4 bath home on beautiful 1.5 acres in the desirable Equestrian/Lake Community of Stone Lake. Awesome location just off 99/Mueschke. 20 minutes to the Woodlands, 45 min to Houston. This home has everything you are looking for including media room, bright study with wood built-ins and formal dining. The open design of the great room with gas fireplace is perfect for entertaining. Beautiful hearthstone kitchen with 5 burner stove top, granite counter tops, huge island and breakfast bar. The wrap around front porch is the ideal place for a cup of coffee with views of the community lake. Enjoy the extended back porch with an irresistible pool. Energy efficiency with natural gas for the fireplace, heater, stove, dryer, and water heaters. Recent renovations include roof (10/22), water heaters (9/21) and carpet (10/22) and fresh paint throughout and updated landscaping. House is on well and septic, so NO MUD TAX!Horses welcome! Tomball ISD Schools! Come see!' ,`Acres` = '1.56' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 2A BLK 3 STONE LAKE PAR R/P 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '67954' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Lake Prcl R/P' ,`TaxAmount` = '9063' ,`TaxRate` = '2.1425' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227178' WHERE `Matrix_Unique_ID` = '212971639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:06:07.997' ,`MLSNumber` = '10219154' ,`ListAgentFullName` = 'Madison Floyd' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = 'Callee Maglothin' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.835176' ,`Longitude` = '-95.456094' ,`PhotoCount` = '30' ,`PostalCode` = '77092' ,`RoomCount` = '6' ,`ListPrice` = '374900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Viking' ,`StreetNumber` = '4304' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1388' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated one story in Oak Forest is move in ready! This house is full of charm starting with it\'s curb appeal with newly painted exterior and new front door. With an oversized backyard on a corner lot and open concept home, this home is ready for entertaining! The granite counters and light cabinetry will delight any home chef. bathrooms beautifully updated with neutral selections to match any pallet. Wood floors throughout, energy efficient windows, 2016 roof & HVAC, 2021 gutters per seller. NEVER FLOODED! Enjoy the parks and trails of the neighborhood as well as convenient access to Downtown, The Heights, and Galleria' ,`Acres` = '0.267' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 8 OAK FOREST SEC 15' ,`LotDesciption` = 'Corner' ,`LotSize` = '11629' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Oak Forest Sec 15' ,`TaxAmount` = '6868' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227178' WHERE `Matrix_Unique_ID` = '213075591' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:09:49.353' ,`MLSNumber` = '29686874' ,`ListAgentFullName` = 'Rhonda Trevino' ,`ListOfficeName` = 'Come Home Realty' ,`SellingAgentFullName` = 'James Tomberlin' ,`SellingOfficeName` = 'RE/MAX Grand' ,`Latitude` = '30.058137' ,`Longitude` = '-95.621361' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '7' ,`ListPrice` = '550000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'La Fouche' ,`StreetNumber` = '26010' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DID YOU HEAR THAT??? IT\'S THE SOUND OF OPPORTUNITY KNOCKING!!-Luxury hooked up with Country resulting in this Captivating Elegant Beauty that you could call HOME. Be prepared to be wowed by the home\'s stunning Dome ceiling in the Living Rm. upon entry, also featuring a cast stone fireplace and open view of the Kitchen. Front Formal dining or Office space to the left of entry; All tile flooring in social areas/ wood flooring in bedrooms; Cast Stone fireplace; Enormous Island in Kitchen; Outdoor kitchen; expanded back porch with a custom cedar bar; Kitchen open to the Living area; EXTRA parking in the extended driveway; Covered RV Storage in back; All this with 3/4 ACRE LOT! Come experience Tranquil Restful Living in the Country yet still Close enough to all the comforts. Set up your private showing today!' ,`Acres` = '0.75' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'LT 74 BOUDREAUX ESTATES SEC 3 U/R ABST 722 A SENECHAL' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '32670' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Boudreaux Estates' ,`TaxAmount` = '8895' ,`TaxRate` = '2.0872' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227179' WHERE `Matrix_Unique_ID` = '213085695' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:08:25.180' ,`MLSNumber` = '50209023' ,`ListAgentFullName` = 'Janelle Williams' ,`ListOfficeName` = 'RE/MAX Cinco Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711940' ,`Longitude` = '-95.859908' ,`PhotoCount` = '50' ,`PostalCode` = '77441' ,`RoomCount` = '9' ,`ListPrice` = '870000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunt Trace' ,`StreetNumber` = '27922' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*VIDEO IS UNDER THE VIRTUAL TAB LINK*Located in the desirable IBIS LAKES section of Cross Creek Ranch. OUTDOOR LIVING is yours to enjoy with SPARKLING POOL & SPA + fabulous COVERED OUTDOOR KITHCEN PAVILLON w/ remote controlled shade. Step inside this 2 story beauty that is ON POINT W/ DESIGNER TRENDS to find 4 BRs, 3 ½ BA. Highly sought after 2nd BR DOWN & EN SUITE BATH. Floorplan includes a handsome STUDY and a CASUAL DINING AREA that opens to a spacious LIVING ROOM boasting SOARING CEILINGS. Stunning GOURMET KITCHEN is complete w/ ENORMUS GRANITE ISLAND, DBL OVENS & LOFTY PANTRY. Inviting Primary suite leads to luxurious bath featuring FREESTANDING TUB & separate shower. Primary CLOSET delights w/ CUSTOM BUILT INS. Head Upstairs to find GMRM + MEDIA and 2 More BRs! Hidden Storage opens to Attic for more storage. SHUTTERS. 3 CAR GARAGE. CULDESAC. Zoned to Award winning KATY ISD. Walk/Bike to Adams JH /Jordan HS. Enjoy 60+ miles of trails, resort pools, dog park & so much more in CCR!' ,`Acres` = '0.2333' ,`Area` = '36' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK COVE AT CROSS CREEK RANCH SEC 5, BLOCK 2, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10162' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '18451' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227179' WHERE `Matrix_Unique_ID` = '213107078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:47:27.520' ,`MLSNumber` = '17437502' ,`ListAgentFullName` = 'Kimblay West' ,`ListOfficeName` = 'Glass House Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809219' ,`Longitude` = '-94.928451' ,`PhotoCount` = '25' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Way Ln' ,`StreetNumber` = '6811' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing 4 bed/2 bath home in Hunters Creek. This home has the ideal open floor plan. Granite kitchen counter tops with a large island. Master suite has whirlpool tub, great after a long hard day. 4th bedroom right off the master suite can be used as a home office. New carpet (9/2022) in living area and front bedrooms. Home equipped with many energy features that you will love. Neighborhood offers a water splashpad and playground within walking distance of home. Comes equipped with security system including doorbell camera. You don\'t want to miss out on this amazing home. Owner is motivated to sell and will consider all offers. Schedule your viewing today! Don\'t wait!' ,`Acres` = '0.1389' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 HUNTERS CREEK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hunters Crk Sec 01' ,`TaxAmount` = '7461' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227179' WHERE `Matrix_Unique_ID` = '213279248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:07:19.937' ,`MLSNumber` = '13595619' ,`ListAgentFullName` = 'Herma Hayes' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = 'Nathan Marks' ,`SellingOfficeName` = 'RE/MAX Integrity' ,`Latitude` = '30.051801' ,`Longitude` = '-95.499545' ,`PhotoCount` = '25' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rosebud Ridge' ,`StreetNumber` = '19431' ,`StreetSuffix` = 'Way' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1895' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained, neat and clean 1 story home with great curb appeal. Large living room with gas log fireplace is open to the kitchen and breakfast areas. Formal dining room can easily be used as a study. Central kitchen has a walk-in pantry, granite counters and updated black appliances. Tile and laminate wood floors in living and wet areas with carpet in the bedrooms. All bedrooms have lighted ceiling fans. Primary suite at the back of the home has double vanities, a jetted tub, separate shower and a huge 10x6 walk-in closet. Plenty of storage space in this home. Utility room has gas and electric dryer connections. Attached double garage has extended side area for even more storage. Yard has an auto sprinkler system for easy maintenance.' ,`Acres` = '0.1611' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 4 STONE FOREST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7017' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Stone Forest Sec 4' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227179' WHERE `Matrix_Unique_ID` = '213396540' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:11:59.303' ,`MLSNumber` = '35924456' ,`ListAgentFullName` = 'Jennifer Barnes' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.572121' ,`Longitude` = '-95.138009' ,`PhotoCount` = '39' ,`PostalCode` = '77062' ,`RoomCount` = '9' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Peermont' ,`StreetNumber` = '15414' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate and well maintained 4 bedroom, 2 and a half bath house conveniently located in central Clear Lake. Large kitchen with plenty of storage and ample counter space opens to the living room and just a step out to the fabulous backyard patio. Great place to enjoy cool fall days and evenings. Backyard gate opens to a great walking area. Extra work and storage space backyard shed as well as the garage. Surround sound in living room and on back porch. Home has tasteful extras, like-new light features in the breakfast area and a large front porch. New 5 ton AC system installed in Sept. 2022. Never flooded and new drainage system recently completed for the street, per seller. New sidewalk and partial driveway to be completed this month. Near shopping, restaurants, entertainment, and walking trails and parks, including Exploration Green. Among the lowest HOA fees in the area. (All measurements are approximate and should be verified.)' ,`Acres` = '0.1741' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 5 MEADOWGREEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7585' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '69' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowgreen Sec 01' ,`TaxAmount` = '5863' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227179' WHERE `Matrix_Unique_ID` = '213425726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:34:16.797' ,`MLSNumber` = '98552240' ,`ListAgentFullName` = 'Sapana Patel' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541776' ,`Longitude` = '-95.564899' ,`PhotoCount` = '32' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Point' ,`StreetNumber` = '5614' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Floor Plan in sought after Riverstone. Zoned to New Elementary opening Fall 2023. It\'s located in a private cul-de-sac at dead end street with no neighbors on one side. Large 4 Bedrooms and 4 Full Bathrooms ( 3 bed downstairs & 1 upstairs); Bay Window in Primary Bedroom, Sunroom, Updated extended patio with outdoor kitchen and grill, natural gas piped to both outdoor cooktop and grill. Open Kitchen with 2 dishwashers , A/C in Garage, The primary bedroom plus 2 bedrooms, formal dining, sun room, breakfast and the study are on the first floor; all bedrooms have en suite bathroom. Second floor game room, a media room and fourth bedroom with a full bath and a walk in closet. Plantation shutters throughout the house. Hard Wood & Tile floors. (Zoned to Anne Sullivan Elementary School) A must see!' ,`Acres` = '0.247' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSTONE VILLAGE AT RIVERSTONE SEC 6 PHASE II, BLOCK 2, LO' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Creekstone Village at Riverstone' ,`TaxAmount` = '11339' ,`TaxRate` = '2.5104' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227180' WHERE `Matrix_Unique_ID` = '213466906' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:43:48.547' ,`MLSNumber` = '41833624' ,`ListAgentFullName` = 'Kayla Brisbin' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.113098' ,`Longitude` = '-95.635274' ,`PhotoCount` = '43' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Pines' ,`StreetNumber` = '14111' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CONCESSION FOR BUY DOWN OR PAINT AVAILABLE, JUST ASK! Stunning custom home located in the privately gated Spring Pines Estates. Vacation all year long in your backyard oasis with a pool & spa, outdoor shower, pool bath, outdoor living & dining areas + a ton of yard left for pets & kids that MUST BE SEEN IN PERSON! Store your boat in the oversized garage built for just that. Sits on a HUGE LOT w/ 3 beds, 2 baths + 2 half baths. Study w/ French doors, formal dining & game room with built-ins. Spacious family room with soaring ceilings open to the elegant island kitchen w/ bar seating, breakfast area + walk-in pantry. Owner’s retreat features a spa-like ensuite w/ double sinks, vanity space, soaking tub, separate shower + HIS AND HER walk-in closets w/ easy asses to laundry room. Alluring front porch, crown molding, gorgeous chandeliers, full gutters, NEW ROOF & A/C & full irrigation. LOCATION LOCATION LOCATION! Zoned to the highly acclaimed Tomball ISD & less than a mile from Tomball HS.' ,`Acres` = '0.3788' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 SPRING PINES ESTATES R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Pines Estates R/P' ,`TaxAmount` = '7341' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227180' WHERE `Matrix_Unique_ID` = '213479159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:44:59.590' ,`MLSNumber` = '25429570' ,`ListAgentFullName` = 'Kristin Kubala' ,`ListOfficeName` = 'Texas Local Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930262' ,`Longitude` = '-95.691450' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '16' ,`ListPrice` = '2100000.00' ,`Status` = 'Active' ,`StreetName` = 'Crestwood Cove' ,`StreetNumber` = '10414' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Breathtaking WATERFRONT estate located on a quiet cul-de-sac & in a gated section of Towne Lake. Mediterranean style elevation that is adorned with lush landscaping, a covered front porch & full sized balcony, 10 ft double doors,eave lighting surrounding the home and a circle driveway in addition to a 4 car garage. You are welcomed by double front doors, grand ceiling height & direct view to the lake. Downstairs you will find your primary bedroom & ensuite and a large private guest suite & 3 additional bedrooms with private baths, gameroom & media room on the second floor. The open concept living room is perfect for your entertaining & family gatherings. The backyard is absolutely spectacular as you have an infinity style pool, hot tub, extended covered patio, outdoor kitchen, separate grotto and seating area, designated firepit seating area, built in trampoline and last, but not least a luxurious covered boat dock and pontoon. Generator, mosquito system etc- too many features to list!' ,`Acres` = '0.3579' ,`Area` = '25' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 TOWNE LAKE SEC 38' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '15590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2235' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '41139' ,`TaxRate` = '3.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227180' WHERE `Matrix_Unique_ID` = '213490767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:50:15.117' ,`MLSNumber` = '19302417' ,`ListAgentFullName` = 'Shermae Lopez' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.100463' ,`Longitude` = '-96.069935' ,`PhotoCount` = '26' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '229999.00' ,`Status` = 'Active' ,`StreetName` = '3rd Street' ,`StreetNumber` = '429' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Energy-efficient home with Low Tax rate! This home is a 2-story plan with 4 bedrooms, 2 bathrooms and 1 half bathroom downstairs. Open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Vinyl plank flooring in living areas and plush carpet in bedrooms with Moen fixtures in a timeless chrome finish throughout the home. Beautiful black appliance package including dishwasher, microwave and electric range, home is all electric with 40-gal water heater, engineered and inspected by third party engineer, 14.5 seer HVAC system, double pane insulated Low-E windows, ENERGY EFFICIENT! LOW ELECTRIC BILLS. Ready to make it yours, easy to show. Warranty: 1 yr. workmanship & materials, 2 yr. on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr. Major Structural components.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NA' ,`LotDesciption` = 'Other' ,`LotSize` = '6200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Town of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667227180' WHERE `Matrix_Unique_ID` = '213507313' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:01:15.323' ,`MLSNumber` = '41189848' ,`ListAgentFullName` = 'Nia Wiltshire' ,`ListOfficeName` = 'Triad One Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692210' ,`Longitude` = '-95.752920' ,`PhotoCount` = '14' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Sierra Bend' ,`StreetNumber` = '21150' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Showings Begin October 19, 2022. Thanks!!!! Well kept 2 story 4/2.5/2 home. 2 story entry way and living room. Primary bedroom located on the first floor. Spacious game room up. You will not be disappointed.' ,`Acres` = '0.1758' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOST CREEK SEC 4, BLOCK 1, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7658' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '726' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lost Creek Sec 4' ,`TaxAmount` = '7167' ,`TaxRate` = '2.7615' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227181' WHERE `Matrix_Unique_ID` = '213536483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:46:42.360' ,`MLSNumber` = '56030313' ,`ListAgentFullName` = 'Marilyn Rodgers' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.770418' ,`Longitude` = '-95.511112' ,`PhotoCount` = '41' ,`PostalCode` = '77320' ,`RoomCount` = '7' ,`ListPrice` = '284900.00' ,`Status` = 'Active' ,`StreetName` = 'Emery Oak' ,`StreetNumber` = '216' ,`StreetSuffix` = 'Way' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1647' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ONE OF A KIND - HOME OFFERS 4 BEDROOMS AND 2 BATHROOM.. ONE OF THE LAST HOMES OFFERED IN THE \"CLASSIC\" PACKAGE... STERLING RIDGE SUB- HIGHLY SOUGHT AFTER NEIGHBORHOOD- YOU WILL LOVE LIVING, SO CLOSE TO EVERYTHING, BUT YET THE COUNTRY FEEL... LIGHT & BRIGHT CONCEPT, HIGH CEILINGS, SITS ON QUIET CUL-DE-SAC SETTING, NO NEIGHBOR BEHIND YOU... KITCHEN OPENS TO LIVING, BREAKFAST BAR, GRANITE COUNTERTOPS, SEPARATE DINING AREA, SELLERS ADDED KITCHEN BACKSPLASH, FIREPLACE, STORMDOOR W/DOGGIE DOOR, 2\"FAUX WOOD BLINDS, STORAGE SHED IN BACK STAYS, ABOVE GROUND POOL WITH DECKING... OVERSIZED PRIMARY SUITE W/ENSUITE BATHROOM, SOAKING TUB, WALK-IN-SHOWER & DUAL SINKS... BACKYARD FENCED & NO NEIGHBOR BEHIND, COVERED PATIO AREA PERFECT FOR THE FAMILY, FRIENDS & PETS...SUB OFFERS KIDS PLAYGROUND AREA... TAKE A STROLL AROUND THE PAVED WALKWAY AROUND THE NEIGHBORHOOD...' ,`Acres` = '0.2118' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING RIDGE SEC-2, BLOCK 2, LOT 29' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '9226' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'STERLING RIDGE' ,`TaxAmount` = '4270' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227181' WHERE `Matrix_Unique_ID` = '213548993' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:49:03.587' ,`MLSNumber` = '29821858' ,`ListAgentFullName` = 'David Granda' ,`ListOfficeName` = 'Blair Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.871701' ,`Longitude` = '-95.478677' ,`PhotoCount` = '29' ,`PostalCode` = '77088' ,`RoomCount` = '4' ,`ListPrice` = '239999.00' ,`Status` = 'Active' ,`StreetName` = 'Darkwood' ,`StreetNumber` = '6007' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home on a cut-de-sac lot in Inwood Forest. Includes a very long driveway and 2 car detached garage. This 4 bedroom 2 bath property has tons of natural lighting with a back yard oasis. Includes nature trails, white oak running/ biking trail and scenic bridge, no back yard neighbors as well as to the left! Renovations include: updated plumbing 2017, updated electrical 2018, garage outfitted with 220V, new 42\" upper kitchen cabinets, solid core doors, tile flooring and updated fixtures, updated ceiling fans, new tile in bathrooms, extended back patio with walkway, freshly trimmed oaks tree and trees. Easy access to 290, 610 and I-10. Near lots of restaurants and night life. This home is priced to sell and won\'t last!!' ,`Acres` = '0.2147' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 INWOOD FOREST SEC 3' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '9354' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SMITH ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Inwood Forest Sec 03' ,`TaxAmount` = '4873' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667227181' WHERE `Matrix_Unique_ID` = '213557994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:14:01.467' ,`MLSNumber` = '88717388' ,`ListAgentFullName` = 'Tabatha Urech' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = 'Tsvetanka Bancheva-Ivanov' ,`SellingOfficeName` = 'EnCourage Realty' ,`Latitude` = '29.792200' ,`Longitude` = '-95.529670' ,`PhotoCount` = '20' ,`PostalCode` = '77055' ,`RoomCount` = '9' ,`ListPrice` = '499000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cedardale' ,`StreetNumber` = '9710' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Renovated Spring Branch one-story ranch home boasts a fantastic location, large backyard and updates galore! Traditional light-filled floorplan features formal living, kitchen with oversized island opening up to the living room and 3 generous bedrooms with two full bathrooms. Kitchen has been tastefully remodeled (2016) with custom cabinetry, gas range, quartzite countertops, and built-in office nook. Utility room doubles as a mudroom and features two hanging bars, granite countertops (perfect for folding!) and tons of storage. Primary suite has large walk-in closet and updated en-suite bathroom with dual sinks and stand-alone shower. Entire home has gorgeous wood-like tile, no carpet! Roof (2015), partial underslab plumbing replaced (2021), Built-in speakers, and so much more! See attachments for full list of improvements. All info per Seller.' ,`Acres` = '0.1791' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 16 LONG POINT WOODS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`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` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Long Point Woods' ,`TaxAmount` = '10152' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227181' WHERE `Matrix_Unique_ID` = '213590376' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:45:31.600' ,`MLSNumber` = '85714091' ,`ListAgentFullName` = 'Derval Romans' ,`ListOfficeName` = 'Ignite Realty Investments' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.969921' ,`Longitude` = '-95.176405' ,`PhotoCount` = '20' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '384900.00' ,`Status` = 'Active' ,`StreetName` = 'Sipsey Wilderness' ,`StreetNumber` = '13419' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to The Groves! This home on Sipsey Wilderness is ready for a new owner in the beautiful city of Humble. This stunning floor plan offers 3 bedrooms, 2.5 bathrooms, and a home office as well! The beautiful kitchen boasts stainless steel appliances, beautiful fixtures, and plenty of granite countertops. Enjoy the evening breeze from the comfort of this amazing back patio. Don’t forget all of the amenities all residents can enjoy in this gorgeous community.' ,`Acres` = '0.1641' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 3 GROVES SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '282' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'The Groves' ,`TaxAmount` = '11187' ,`TaxRate` = '3.443' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227181' WHERE `Matrix_Unique_ID` = '213606167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:06:23.140' ,`MLSNumber` = '36614592' ,`ListAgentFullName` = 'Errol Nolan' ,`ListOfficeName` = 'Olympic Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766621' ,`Longitude` = '-95.734620' ,`PhotoCount` = '22' ,`PostalCode` = '77450' ,`RoomCount` = '8' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Westgreen' ,`StreetNumber` = '1239' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2109' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and Check out this Opportunity! Spacious 4 bedroom Home with formal living and Dining large cover patio. Have tons of potential and great bones in a prime area.' ,`Acres` = '0.202' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 10B & 11A BLK 20 MEMORIAL PARKWAY SEC 6 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MEMORIAL PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Pkwy Sec 06 R/P' ,`TaxAmount` = '4662' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227182' WHERE `Matrix_Unique_ID` = '213628515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:36:38.193' ,`MLSNumber` = '22682118' ,`ListAgentFullName` = 'Jarrod Jenkins' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810635' ,`Longitude` = '-95.419667' ,`PhotoCount` = '28' ,`PostalCode` = '77008' ,`RoomCount` = '9' ,`ListPrice` = '539000.00' ,`Status` = 'Active' ,`StreetName` = 'Beall Landing' ,`StreetNumber` = '1125' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous & Updated two-story patio home in a gated community in Shady Acres. First floor living and kitchen design, this home also has a secondary flex space upstairs that can be used as living, study, game or play space. Two-car garage with double wide private driveway. Huge island is perfect for family gatherings. Real oak floors, plantation shutters, and large closets. Great location and move in ready! Schedule your showing today!' ,`Acres` = '0.0574' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 GARDENS AT SHADY ACRES AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gardens/Shady Acres Sub 1' ,`TaxAmount` = '9148' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227182' WHERE `Matrix_Unique_ID` = '213681615' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:33:48.860' ,`MLSNumber` = '21321027' ,`ListAgentFullName` = 'Eleazar Mendez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928513' ,`Longitude` = '-95.679244' ,`PhotoCount` = '29' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Little Riata' ,`StreetNumber` = '17315' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2414' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in the highly desirable community of Riata Ranch, this single-story home offers an open floorplan, high ceilings, and lots of natural light. With kitchen overlooking the family room and connected to the breakfast nook, this is a great home for entertaining. This home comes with lots of upgrades, including new light fixtures throughout the home, recently installed hard wood floors, huge custom backyard patio, updated kitchen and bathrooms, custom fireplaces, and so much more. Garage has been converted into game room and can be used as a 5th room. Mature trees around the home provide plenty of shade. Community offers parks, pool, and walking trails. Home is minutes from the Boardwalk at Towne Lake, Houston National Golf Course, and has easy access to major highways. Zoned to highly rated Cy-Fair ISD schools. Home has NEVER flooded. Schedule your showing today!' ,`Acres` = '0.1567' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 RIATA RANCH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '844' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WOODARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riata Ranch Sec 01' ,`TaxAmount` = '6971' ,`TaxRate` = '2.711' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227182' WHERE `Matrix_Unique_ID` = '213727075' --> 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','213813039','1667227182','213813039','2022-10-30T21:41:21.680','24323874','Jassae Peed','HomeSmart','','','29.797001','-95.575258','25','77043','7','509000.00','Active','Wrenwood','1748','Lakes','Houston','3','1','3','2888','Single-Family','Fabulous gated subdivision, located in Upland Lakes. Gorgeous lakes, walking trails, pools, dog park, and more. This is a custom designed, upgraded Uptown home. Perfect for entertaining. Hardwood floors, quarts counter tops, large den/3rd bedroom downstairs with a full bath. Double doors open to a spacious deck and private garden patio. The 2nd floor has an open floor plan with high ceilings, chef\'s kitchen with Bosch stainless appliances, new granite countertops with a large island, and a gas cook top. There is a study off the kitchen, a designated dining area, living room has a beautiful fireplace with a new mantle. On the 3rd floor is the master suite with a spacious bathroom and huge walk in closets. A 2nd bedroom is also located on the 3rd floor with a private bath. This home comes with multiple walk in closets, plenty of storage.','0.0568','24','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Spring Branch','Central Gas','1','LT 13 BLK 3 UPLAND PARK 2ND PAR R/P','Corner','2474','Appraisal District','','2900','0','','2','Single Oven','0','','','','','Composition','49 - Spring Branch','SHERWOOD ELEMENTARY SCHOOL','STRATFORD HIGH SCHOOL (SPRING BRANCH)','SPRING FOREST MIDDLE SCHOOL','Supra Keybox','Appraisal District','3','Contemporary/Modern','Upland Park Pt Rep 2','11102','2.4415','Public Sewer,Public Water','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213864863','1667227182','213864863','2022-10-30T21:37:15.747','53115677','Max Arredondo','Riverbend Realty Group','','','29.467555','-95.114973','44','77573','9','540000.00','Active','Apache','2608','Street','League City','2','0','4','2167','Single-Family','Beautiful 4/2 Cervelle One Story in highly sought neighborhood of Sedona in League City with oversized barn style 4 car garage with staircase leading to ample storage area which can be designed as an additional living space or entertainment area. 9ft door on back of garage, Porte-cochere for extra parking, large yard & the property sits on 0.49 acre with room for pool or other outdoor living space with a larger electrical panel already available. Electric roller shades in the living room and breakfast area. Modern kitchen with granite counter tops, cabinets including under cabinet lighting, black appliances, walk-in pantry, large utility room, UV DR window film on all windows of the home to reduce electric bill and so much more! 4th Bedroom is currently used as a Home Office with French Doors and a view of the large front yard. The home sits at the end of the street close to the cul de sac. Great golf cart community neighborhood! Make your appointment to see this home soon!','0.4942','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','League City','Central Gas','1','LOT 6 BLK 1 SEDONA SEC 6 PH 1 (2020) ABST 19','Subdivision Lot','21529','Appraisal District','','300','0','','4','Gas Oven','0','','','Gas Cooktop','','Composition','17 - Dickinson','CALDER ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox','Builder','1','Traditional','Sedona','13594','3.4497','Public Sewer,Public Water','2020','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:42:24.313' ,`MLSNumber` = '41878538' ,`ListAgentFullName` = 'Taylor Koehne' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Mary Townsend' ,`SellingOfficeName` = 'Goldmount Real Estate Group' ,`Latitude` = '29.750769' ,`Longitude` = '-95.848849' ,`PhotoCount` = '47' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '695000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Walsh Crossing' ,`StreetNumber` = '27827' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SELLERS OPEN TO PROVIDING BUYER CREDIT/SUBSIDY TO REDUCE BUYER\'S INTEREST RATE (2-1 BUY DOWN PROGRAM, Buyer will need a lender who offers this loan program) \r\nWelcome home to this pristine home located in the sought after Firethorne community. This 3787 sqft home features: 5 bedrooms, 4.5 bathrooms, double ovens, media room, game room, private home office/study, outdoor kitchen, heated pool (with upgraded 25 year pebble tech) and spa of your dreams, Situated on a large corner lot with green space behind it. Firethorne has beautiful walking and biking trails, community pools and so many more amenities to discover, along with highly acclaimed Katy ISD schools. Enjoy the resort style living in this beautiful community, along with low tax rates! Schedule your private showing today!' ,`Acres` = '0.2462' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE SEC 19, BLOCK 1, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10726' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Firethorne Sec 19' ,`TaxAmount` = '12903' ,`TaxRate` = '2.6945' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227182' WHERE `Matrix_Unique_ID` = '213865550' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:31:18.040' ,`MLSNumber` = '21627214' ,`ListAgentFullName` = 'Bridget Moore' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.215468' ,`Longitude` = '-95.538910' ,`PhotoCount` = '33' ,`PostalCode` = '77382' ,`RoomCount` = '7' ,`ListPrice` = '519900.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle Mead' ,`StreetNumber` = '43' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2202' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! This beautiful brick 2 bedroom, 2 bath home with office is located in the sought-after Alden Bridge subdivision in the heart of The Woodlands. From the moment you walk in, you will love the immaculate wood floors that lead into the large living room with built ins and wood burning fireplace. The Gourmet kitchen offers stainless appliances including a gas range, island, and plenty of cabinet and counter space. You will appreciate the split floor plan with massive primary bedroom featuring an ensuite bathroom with double sinks, separate shower and jetted tub, and walk in closet. Relax and unwind in your own oasis of a backyard with stone walkways, beautiful pool with waterfall feature, and large covered patio. Close to shopping and all that The Woodlands has to offer!' ,`Acres` = '0.1502' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S971963 - WDLNDS VIL ALDEN BR 63, BLOCK 2, LOT 12' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6541' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 63' ,`TaxAmount` = '8472' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227183' WHERE `Matrix_Unique_ID` = '213876693' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:46:56.873' ,`MLSNumber` = '48605809' ,`ListAgentFullName` = 'Dubelsa Salinas' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821899' ,`Longitude` = '-94.990765' ,`PhotoCount` = '24' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Flycatcher' ,`StreetNumber` = '4518' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2369' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CASTLE ROCK HOME just minutes from I-10 w/ an easy commute to all that Downtown Houston has to offer. This two story 4 bed, 2.5 bath, 2 car garage home features a spacious kitchen w/ breakfast nook and a MASSIVE family room - perfect for entertaining! GRANITE kitchen, 42\'\' cabinetry! Luxury master suite w/ HUGE walk-in closet, double sinks & separate tub/shower! Gameroom located upstairs, generous secondary bedrooms with a HUGE WALK-IN CLOSET in the third bedroom!! \r\n\r\nAmenities :Enjoy a 9-acre lake, walking trails, parks, & more.' ,`Acres` = '0.1323' ,`Area` = '2' ,`BuilderName` = 'Castle Rock Comm.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 GOOSE CREEK LANDING SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5763' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Goose Crk Lndg Sec 3' ,`TaxAmount` = '8981' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227183' WHERE `Matrix_Unique_ID` = '213894789' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:35:39.870' ,`MLSNumber` = '75610839' ,`ListAgentFullName` = 'Kathleen Lauhoff' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Christi Borden' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.766764' ,`Longitude` = '-95.632416' ,`PhotoCount` = '36' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Swiss Hill' ,`StreetNumber` = '13907' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION! This home is zoned to acclaimed BARBARA BUSH Elem School & located in the highly desirable ENERGY CORRIDOR, near Terry Hershey Park Hike/Bike Trails, with easy access to I-10, City Centre, & local restaurants. There is a new community center & all the amenities are located nearby on Briarhills Parkway. This is a BEAUTIFUL 1-story home. with NO CARPET. It has a custom gate and double door entry that welcomes you when you arrive, 3 large bedrooms, 2 bathrooms, plus a study with block paneling and bookshelves that could be used as a 4th bdrm, with tile floors throughout. Many other features include: canvas awnings on the south & east side of home, French doors in study and kitchen/breakfast room, automatic sprinkler system, landscaped back yard with Koi fish pond + patio w/brick pavers. A/C coil & condenser (2011), oven, microwave, dishwasher (2013-2015). Access to area tennis courts, pool, basketball courts and club house. NEVER FLOODED! A MUST SEE!!' ,`Acres` = '0.1362' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 9 BRIARHILLS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5933' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '916' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarhills' ,`TaxAmount` = '5943' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227183' WHERE `Matrix_Unique_ID` = '213898799' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:20:23.453' ,`MLSNumber` = '53454988' ,`ListAgentFullName` = 'Keith Owens' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545353' ,`Longitude` = '-95.030847' ,`PhotoCount` = '35' ,`PostalCode` = '77565' ,`RoomCount` = '6' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest' ,`StreetNumber` = '905' ,`StreetSuffix` = 'Road' ,`City` = 'Clear Lake Shores' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1562' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NICELY RENOVATED AND MOVE-IN READY HOME WITH POOL IN SOUGHT AFTER WATERFRONT\r\nCOMMUNITY OF CLEAR LAKE SHORES! INTERIOR FEATURES WOOD AND TILE FLOORS THROUGHOUT,\r\nSPACIOUS LIVING ROOM W/ FIREPLACE, BOTH PRIMARY SUITE & SECONDARY BEDROOM FEATURE A\r\nFULLY UPDATED BATH AND WALK-IN CLOSET. ENJOY THE OUTDOORS ON THE FRONT AND BACK\r\nBALCONIES, RECENT POOL (2022) WITH TANNING LEDGE, COVERED PATIO AND DON\'T FORGET THE\r\nCHICKENS! YOU\'LL LOVE THE DOUBLE WIDE DRIVEWAY AND AIR-CONDITIONED GARAGE WITH GOLF\r\nCART GARAGE, WORKSHOP AND 2 GARAGE DOORS THAT OPEN TO THE BARKYARD TO DOUBLE YOUR\r\nOUTDOOR LIVING! UPDATES INCLUDE HARDIPLANK EXTERIOR (2021) AND WATER HEATER (2021).\r\nWATERFRONT LEASE ON CLEAR LAKE IS ALSO AVAILABLE TO PURCHASE SEPARATELY.' ,`Acres` = '0.13' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOTS 915, 916, 917, ABST 18 M MULDOON SUR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'CLEAR LAKE SHORES' ,`TaxAmount` = '5676' ,`TaxRate` = '1.83' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227183' WHERE `Matrix_Unique_ID` = '213916334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:36:39.463' ,`MLSNumber` = '67107261' ,`ListAgentFullName` = 'Curtis McAnulty' ,`ListOfficeName` = 'Texas American Realty' ,`SellingAgentFullName` = 'Curtis McAnulty' ,`SellingOfficeName` = 'Texas American Realty' ,`Latitude` = '29.583642' ,`Longitude` = '-95.265873' ,`PhotoCount` = '39' ,`PostalCode` = '77581' ,`RoomCount` = '10' ,`ListPrice` = '699990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Garden Glen' ,`StreetNumber` = '1403' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately traditional home in the gated Ayershire section of the Lakes of Highland Glen. This elegantly updated home features a massive primary suite with sitting area, guest room with en-suite bathroom and three large additional bedrooms upstairs. Additional features include separate study, oversized media room, game room, formal dining, breakfast nook and large open concept family room. This beautiful home features water views from every room. New roof and gutters installed in August 2022 and variable speed American Standard air-conditioners for ultimate comfort and energy efficiency installed in 2021. Other recent updates include engineered hardwood flooring, custom paint, plantation shutters, Viking kitchen appliances, RH light fixtures and recessed lighting throughout. Custom Pool design has been created for the property to embrace the large backyard and water views. ONLY a 25 minute drive to the Medical Center, Downtown Destinations and 20 Minutes from Baybrook Mall.' ,`Acres` = '0.2798' ,`Area` = '5' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE LAKES AT HIGHLAND GLEN SEC 11 (A0076)(PEARLAND) BLK 5 LO' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '12188' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'BARBARA COCKRELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes At Highland Glen Sec' ,`TaxAmount` = '16982' ,`TaxRate` = '2.9952' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667227183' WHERE `Matrix_Unique_ID` = '213941929' --> 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','213945896','1667227184','213945896','2022-10-30T20:40:30.553','98134164','Andrea Cooksey','Exit Realty 360','','','29.853557','-95.281472','9','77078','9','225000.00','Active','Claiborne','7918','Street','Houston','2','0','4','1815','Single-Family','This is size and location perfect for growing family or investment opportunities. Huge 4 bedroom 2 bath double car garage. This custom built home need a little cosmetic love but could occupy today. Room measurements are approximate so please confirm.','0.1419','2','','','','','Sellers Disclosure','','Gaslog Fireplace','1','Northeast Houston','Central Gas','0','LT 45 BLK 2 PARK NORTH SEC 2 R/P','Subdivision Lot','6180','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','HILLIARD ELEMENTARY SCHOOL','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Vacant/Unoccupied','Appraisal District','1','Traditional','Park North Sec 02 R/P','3586','2.3307','Public Sewer,Public Water','1978','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:19:19.203' ,`MLSNumber` = '75834132' ,`ListAgentFullName` = 'Terry Harvey' ,`ListOfficeName` = 'Twin Dove Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.555984' ,`Longitude` = '-95.680584' ,`PhotoCount` = '10' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Greatwood Lake' ,`StreetNumber` = '7310' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in Greatwood Shores this 4 bedroom, 3 full and 2 half custom home, sits on over 1/4 acre lot. It is situated on the golf course second hole with a panoramic lake view. The floor plan is the perfect combination of open concept and intimate gathering spaces for entertaining. Spacious primary bedroom, study and game room on the second floor. Three car garage with additional carport parking. Convenient access to Hwy 59 and Greater Houston, zoned to Lamar Consolidated School district. During the 2021 freeze water pipe leak and owner removed drywall, appliances, and flooring. Ready for a new buyer to come in with their vision.' ,`Acres` = '0.3831' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Levee District' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD SHORES SEC 1, BLOCK 1, LOT 3' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '16689' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'DICKINSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Greatwood Shores Sec 1' ,`TaxAmount` = '14887' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227184' WHERE `Matrix_Unique_ID` = '213969443' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:32:48.337' ,`MLSNumber` = '87231838' ,`ListAgentFullName` = 'Ebin Kurian' ,`ListOfficeName` = 'Stride Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.037374' ,`Longitude` = '-95.566258' ,`PhotoCount` = '41' ,`PostalCode` = '77422' ,`RoomCount` = '3' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Camellia' ,`StreetNumber` = '231' ,`StreetSuffix` = 'Drive' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled home conveniently located near TX-36 and FM 521 in the center of Brazoria. This house has new paint and comes with a new AC system, new ducts, a new light fixture, new flooring, and completely remodeled bathrooms. Additionally, the freshly refurbished kitchen also has a refrigerator, a microwave, an oven, a dishwasher, a washing and dryer. This 3 bed 2 bath home also features a spacious lot which also has a remodeled in-ground pool, perfect for entertaining!' ,`Acres` = '0.3857' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MAGNOLIA GARDENS (BRAZORIA) BLK 3 LOT 10-12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Vinyl Lined' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Gardens Brazoria' ,`TaxAmount` = '4056' ,`TaxRate` = '2.3372' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227184' WHERE `Matrix_Unique_ID` = '214069321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:52:50.800' ,`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` = '269500.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`='1667227184' WHERE `Matrix_Unique_ID` = '214091890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:01:54.810' ,`MLSNumber` = '87962671' ,`ListAgentFullName` = 'Angie Middlebrooks' ,`ListOfficeName` = 'RE/MAX TRADITIONS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.520575' ,`Longitude` = '-95.717126' ,`PhotoCount` = '46' ,`PostalCode` = '77469' ,`RoomCount` = '11' ,`ListPrice` = '1724999.00' ,`Status` = 'Active' ,`StreetName` = 'Misty Meadow' ,`StreetNumber` = '7534' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite equestrian estate nestled in the heart of Ft. Bend County, in the premier Bridlewood Estates. Enjoy all the amenities of suburbia & easy freeway access w/the serenity of country living. With 5+ acres, a giant shop, 4 horse stables, three rail fencing for miles & a resort style pool/spa, you may never want to leave HOME. The interior offers a casual elegance w/upgrades throughout & attention to detail in every room. The kitchen is a chef\'s dream & there is room for everyone to keep you company. The primary bedroom provides a sanctuary w/ access to a private deck. Revel in the primary bath finishes and enjoy your private spa. A split-plan design places the secondary bedrooms adjacent to the game room for entertaining and/or kid-retreat perfection. Take in the outdoors on your screened in porch & allow the misting system to rid you of the pesky bugs. Don\'t miss the whole house generator, smart thermostat, extensive irrigation system, horse trailer parking & flower gardens...' ,`Acres` = '5.35' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BRIDLEWOOD ESTATES SEC 1, BLOCK 8, LOT 17&18, ACRES 5.35' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Wooded' ,`LotSize` = '135689' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CARTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Bridlewood Estates Sec 1' ,`TaxAmount` = '10571' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227184' WHERE `Matrix_Unique_ID` = '214092985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:35:38.480' ,`MLSNumber` = '53731175' ,`ListAgentFullName` = 'Jerry Rubli' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.010614' ,`Longitude` = '-95.487504' ,`PhotoCount` = '39' ,`PostalCode` = '77068' ,`RoomCount` = '11' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Banty Falls' ,`StreetNumber` = '15502' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3091' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large traditional home at the end of a quiet cul-de-sac with mature trees on an oversized lot. Completely enclosed patio, gas log fireplace and wet bar with a large playroom upstairs. His and hers closets and double sinks in the master bathroom and second bathroom. Lots of storage and built in cabinets. Flooring in study, dining room and family room replaced 8 years ago. Roof replaced 4 years ago. A/C is 9 years old.' ,`Acres` = '0.2415' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 14 OLDE OAKS SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '445' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olde Oaks Sec 01' ,`TaxAmount` = '5536' ,`TaxRate` = '2.3342' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227184' WHERE `Matrix_Unique_ID` = '214103988' --> 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','214105249','1667227185','214105249','2022-10-30T21:39:32.870','23360537','Karen Hernandez','NB Elite Realty','','','29.598364','-95.238188','11','77089','4','250000.00','Active','Sagevale','10318','Lane','Houston','2','0','4','1434','Single-Family','Beautiful Home!!!\r\n4 beds, 2 baths, a spacious living area and 2 car garages .New roof, new AC and new gutters.Plenty of yard for the family and pets! Easy access to major freeways, Beltway 8 and I-45. YOU MUST SEE!!!','0.1641','3','','','Electric Dryer Connections','','Sellers Disclosure,Tenant Occupied','1','','','Southbelt/Ellington','Central Gas','1','LT 13 BLK 6 KIRKMONT SEC 1','Subdivision Lot','7150','Appraisal District','','180','0','','','Single Oven','0','','','Gas Cooktop','','Composition','41 - Pasadena','MOORE ELEMENTARY SCHOOL (PASADENA)','DOBIE HIGH SCHOOL','BEVERLYHILLS INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Kirkmont Sec 01','4124','2.6655','Public Water','1975','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:04:19.773' ,`MLSNumber` = '51703912' ,`ListAgentFullName` = 'Les Strech' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768412' ,`Longitude` = '-95.742644' ,`PhotoCount` = '26' ,`PostalCode` = '77450' ,`RoomCount` = '7' ,`ListPrice` = '268500.00' ,`Status` = 'Active' ,`StreetName` = 'Park Wick' ,`StreetNumber` = '21414' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2168' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION! WELCOME to 21414 Park Wick located on a quiet street in the desirable, established community of Memorial Parkway. This home offers a great floor plan with 2 large living areas for friends and family areas...both located downstairs. A large and open Kitchen area as well as Breakfast Room has great space. The Primary Bedroom and Secondary Bedrooms are spacious with great closet space. The home has updated flooring throughout. (October 2022). Additional updates include the beautifully and refreshed Bathrooms up and Guest Half Bath down. The Interior is newly painted with updated tones. The home features Double Pane Insulated windows for energy efficiencies as well as ceiling fans. The large backyard is a blank slate to create a great play place or outdoor living. GREAT location- Katy ISD schools, near shopping and entertainment with easy access to major freeways - energy corridor, Grand Parkway 99, and West Park Tollway. Call TODAY to see! This HOME won\'t last long!!!' ,`Acres` = '0.1637' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 10 BLK 11 MEMORIAL PARKWAY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MEMORIAL PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Pkwy Sec 02' ,`TaxAmount` = '4471' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227185' WHERE `Matrix_Unique_ID` = '214153668' --> 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','214170297','1667227185','214170297','2022-10-30T21:15:56.780','53947166','Jennifer White','Creighton Realty Partners, LLC','','','30.309686','-95.552754','33','77316','8','784500.00','Active','Skipper Jack','129','','Montgomery','3','0','4','3230','Single-Family','Meticulously kept custom home on a private wooded lot in Ridgelake Shores. This gorgeous four bedroom home has two bedrooms downstairs and two bedrooms upstairs with a bonus room that could be used for another bedroom or media room. This home is situated on a 1.035 lot offering a lot of privacy and tranquility of nature and wildlife. The subdivision boosts a community lake and park with covered pavilion for residents use.','1.035','39','ADAC Home Builder','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Conroe Southwest','Central Electric,Central Gas','1','S827104 - RIDGELAKE SHORES 04, BLOCK 1, LOT 54','Subdivision Lot,Wooded','45085','Appraisal District','','350','0','','3','Gas Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Ridgelake Shores 04','11935','2.0209','Aerobic,Public Water','2018','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:27:31.080' ,`MLSNumber` = '19802971' ,`ListAgentFullName` = 'Catrina Figueroa' ,`ListOfficeName` = 'Realty Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.266481' ,`Longitude` = '-95.438496' ,`PhotoCount` = '46' ,`PostalCode` = '77302' ,`RoomCount` = '5' ,`ListPrice` = '659000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon Crest' ,`StreetNumber` = '13245' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 New A/C units, New pool filter, New pool heater. This charming two-story brick home in the highly desirable neighborhood of Crighton Ridge is ideally located near a host of amenities such as Lake Conroe, Sam Houston National Forest, The Woodlands, Big Rivers water Park and much more. The home is situated on a grand corner lot of over 37,000 sq ft and is nestled between a variety of large mature trees. If you want the community experience without being on top of the neighbor\'s house this is the home for you. Whether you are looking for dinning, shopping, or entertainment you\'re sure to only be a short drive away. Enjoy the sunset colors in the sky from the large front covered porch or entertain guests from the comfort of a large covered back patio as they swim in your pool.' ,`Acres` = '0.8535' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CRIGHTON RIDGE 02, BLOCK 4, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '37179' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Photos/No Videos,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Crighton Ridge 02' ,`TaxAmount` = '12174' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227185' WHERE `Matrix_Unique_ID` = '214174028' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:57:42.253' ,`MLSNumber` = '24211660' ,`ListAgentFullName` = 'Helen Nguyen' ,`ListOfficeName` = 'LV Realty & Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.970747' ,`Longitude` = '-95.615535' ,`PhotoCount` = '27' ,`PostalCode` = '77429' ,`RoomCount` = '10' ,`ListPrice` = '639000.00' ,`Status` = 'Active' ,`StreetName` = 'Lismore Lake' ,`StreetNumber` = '12131' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Lismore Lake Estates, your new year round at home vacation. with tranquility water views and gorgeous swimming pool. This 5 bedrooms, 3.5 baths home is situated on large corner lot and water front & Beautiful landscaping. Elegant entry way with wood flooring, wrought iron stair case, High ceilings, & Kitchen that opens to family room. Primary room and game room have backyard water view. And balcony that looks over the water as well. New Roof 2020. Zoned to highly acclaimed CFISD schools. Ready to move in by the upcoming holidays!' ,`Acres` = '0.2037' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 107 BLK 1 LISMORE LAKE ESTATES' ,`LotDesciption` = 'Corner,Waterfront' ,`LotSize` = '8874' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Left Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lismore Lake Estates' ,`TaxAmount` = '11072' ,`TaxRate` = '2.7587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227185' WHERE `Matrix_Unique_ID` = '214195206' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:10:56.260' ,`MLSNumber` = '41660258' ,`ListAgentFullName` = 'Jennifer Allison' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.715667' ,`Longitude` = '-95.353745' ,`PhotoCount` = '11' ,`PostalCode` = '77004' ,`RoomCount` = '2' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Wentworth' ,`StreetNumber` = '3806' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Being walking/biking distance to both Texas Southern and the University of Houston, this property is a great investment opportunity after repairs!!! or if you\'re looking to get into the area-this is the perfect house to make a home at an affordable price to fit the current market trends.' ,`Acres` = '0.1515' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 4 OAK MANOR SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Manor' ,`TaxAmount` = '2714' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227185' WHERE `Matrix_Unique_ID` = '214200111' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T20:23:28.873' ,`MLSNumber` = '33377406' ,`ListAgentFullName` = 'Susana Ortiz' ,`ListOfficeName` = 'First Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563596' ,`Longitude` = '-95.817232' ,`PhotoCount` = '9' ,`PostalCode` = '77471' ,`RoomCount` = '6' ,`ListPrice` = '238000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue D' ,`StreetNumber` = '1005' ,`StreetSuffix` = '' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House is larger then description (approx. 1600sq ft). Completely remodeled from the outside to the inside. New attractive driveway and sidewalk. New doors through out. Recent roof. Recently renovated a/c, bathrooms, kitchen, flooring, plumbing, electrical etc. Large fenced yard. Shed with a/c unit and lighting. On an established quiet neighborhood. Bedroom sizes are approximate sizes. NO HOA and LOW TAXES. Never Flooded! A must see and close to everything. More pictures and docs coming soon.' ,`Acres` = '0.1377' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RIVERSIDE TERRACE SEC 3, BLOCK 1, LOT 12' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'JACKSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Riverside Terrace Sec 3' ,`TaxAmount` = '1386' ,`TaxRate` = '2.0748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227186' WHERE `Matrix_Unique_ID` = '214205800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-30T21:57:18.323' ,`MLSNumber` = '29808347' ,`ListAgentFullName` = 'Chris Lawrence' ,`ListOfficeName` = 'Trillionaire Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.611916' ,`Longitude` = '-95.439933' ,`PhotoCount` = '44' ,`PostalCode` = '77053' ,`RoomCount` = '7' ,`ListPrice` = '318900.00' ,`Status` = 'Active' ,`StreetName` = 'Nathans Park' ,`StreetNumber` = '4147' ,`StreetSuffix` = 'Place' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated three story home with 5 bedrooms, 3 and a half baths and 2 car garage. Open floor plan, breakfast bar and stainless steel appliances. Schedule your showing today.' ,`Acres` = '0.0831' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 1 GALLERIA ESTATES AT WHITE HEATHER AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3621' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Galleria Ests/White Heather Am' ,`TaxAmount` = '3756' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667227186' WHERE `Matrix_Unique_ID` = '214209899' --> 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','214220983','1667227186','214220983','2022-10-30T21:59:07.740','25355962','Ali Huneiti','Texas Signature Realty','','','33.885838','-98.484182','7','76302','2','98000.00','Active','Hill','2808','Street','Wichita Falls','1','0','2','704','Single-Family','Location Location Location Residential/ Commercial on top of the Hill Across From Car Dealer Patterson Honda and Next to La Casita Boat Dealer, This Investors Opportunities Great Location 2 Bed Rooms One Full Bath Room , Living Room , Kitchen, and Nice Back Yard , This Residential /Commercial Area , House Need Some Work, Please Make Appointment to see the House, Call Listing Agent Send Offers to ali.huneiti@icloud.com','0.1928','84','','','','','Owner/Agent','0','','','','No Heating','0','LOT 5-N10 FT LOT 6 BLK 3 VISTA HEIGHTS','Cleared,Patio Lot','8398','Appraisal District','','','0','','','','0','','','','','Composition','1036 - Wichita Falls','SOUTHERN HILLS ELEMENTARY SCHOOL','WICHITA FALLS HIGH SCHOOL','BARWISE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Back,Lockbox Front','Appraisal District','1','Traditional','Vista Heights','315','2.5512','Public Sewer,Public Water','1948','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','214220989','1667227186','214220989','2022-10-30T21:12:01.660','62523986','Scott Landreth','BHGRE Gary Greene','','','29.979832','-95.484411','11','77014','8','230000.00','Active','Chasewick','4102','Circle','Houston','2','1','3','2405','Single-Family','This is a house with large rooms and a gigantic backyard - easily big enough for a pool. Gorgeous home renovated in 2012 with nice details like granite countertops/stunning backsplash tile designs in the kitchen and bathrooms; GE stainless steel appliances, tile, carpet, recessed lighting, light fixtures, engineered wood flooring, fans, rebuilt staircase and cement-board plank siding! Great opportunity for a starter home. Come by see it.','0.2044','13','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Reports Available,Sellers Disclosure','1','Gas Connections','1','1960/Cypress Creek South','Central Gas','1','LT 24 BLK 5 HAMBLEDON SEC 2','Cul-De-Sac','8904','Appraisal District','','450','0','','2','Electric Oven','0','','','Gas Range','','Composition','48 - Spring','BENEKE ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','EDWIN M WELLS MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Hambledon Sec 02','6123','2.7767','Water District','1982','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','214222944','1667227186','214222944','2022-10-30T20:03:16.987','88718889','Velanka Antao','Keller Williams Realty -SW','','','29.729338','-95.345384','25','77004','4','350000.00','Active','Tuam','3820','Street','Houston','2','0','3','1250','Single-Family','Location! Location! Location!! This property is in walking distance to University of Houston central campus. Fully remodeled home with tones of upgrades. Never flooded!! There are 3 bedrooms and 2 full bath. Easy excess to major highways including I-45 and U.S. 59.','0.1148','4','','','Gas Dryer Connections','','Sellers Disclosure','1','','','University Area','Central Gas','0','LT 7 BLK X LEELAND PARK','Other','5000','Appraisal District','','','0','','2','','0','','','Electric Cooktop','','Composition','27 - Houston','BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','1','Traditional','Leeland Park','2748','2.3307','Public Sewer,Public Water','1936','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','214224075','1667227186','214224075','2022-10-30T20:42:11.830','51246384','Isaac Tijerina','Tijerina Group','','','29.701020','-95.522069','29','77036','10','200000.00','Active','Croton','7507','Road','Houston','2','0','3','1737','Single-Family','Excellent location, within minutes of HBU, Galleria, & Downtown. Easy access to 59/I69, Westpark Tollway, & Sam Houston Tollway. 3 Bedroom, 2 bath home with all appliances including washer & dryer. Spacious back yard with concrete patio ready for outdoor living/chilling area. No carpet, all ceramic tile throughout & granite countertops in kitchen & baths. Upon entry, you will be greeted by large formal den and dining area with lots of natural light. The cook will enjoy all the cabinet space in the kitchen. The living area has a convenient built-in bookcase for library or board games to enjoy family game nights. One bedroom has built in workstation, perfect to work from home or study room. Call you Realtor to show you this one ASAP!','0.1901','21','','','Electric Dryer Connections,Washer Connections','','Estate,Sellers Disclosure','1','','','Sharpstown Area','Central Gas','0','LT 18 BLK 7 SHARPSTOWN SEC 5','Subdivision Lot','8280','Appraisal District','','','0','','','Gas Oven','0','','','Electric Cooktop','','Other','27 - Houston','NEFF ELEMENTARY SCHOOL','SHARPSTOWN HIGH SCHOOL','SUGAR GROVE MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Sharpstown Sec 05','4352','2.3307','Public Sewer,Public Water','1961','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','214224269','1667227186','214224269','2022-10-30T21:19:40.840','69906879','Jamie Graves','eXp Realty, LLC','','','29.830965','-94.842524','34','77523','9','533000.00','Active','Joe Louis','9219','Drive','Mont Belvieu','3','1','4','3173','Single-Family','Completely upgraded brick and stone elevation with a 3 Car garage for your extra vehicles or workshop. The 8 foot entrance brings you into a beautiful breezeway/utility room and formal dining area. The kitchen is fully equipped with quartz counter tops, White shaker cabinets with gold accents, chefs kitchen with a coffee bar, and a pot & pan drawer below a 5 gas burner stovetop. The open concept living area has high ceilings perfect for entertaining. Large backyard with covered patio. Master suite with walk-in shower and tub Upstairs game room and media room along with 3 bedrooms ,walk-in closets and 2 full baths. This home has all the amenities and more including a built in water sprinkler system, zoned AC unit, tankless water heater, Attic with Foam/blown insulation, crown molding throughout the house, and a KEVO door lock on the front door. This estate home is located in the Barbers Hill School district, with access to great restaurants and shopping .','0.2238','53','','','Gas Dryer Connections,Washer Connections','','Other Disclosures','1','Gas Connections','1','Chambers County West','Other Heating','1','LT21 BK1 RESERVES OF CHAMPIONS ESTATES SECTION 1 2022 TASK','Subdivision Lot','9749','Appraisal District','','375','0','','3','Electric Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL NORTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL NORTH MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','2','Traditional','Reserve/Champions Ests Sec 1','540','2.1606','Public Sewer,Public Water','2021','Appraisal District'); --> New record created successfully