Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:15:57.740' ,`MLSNumber` = '30683484' ,`ListAgentFullName` = 'Bob Ge' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.742055' ,`Longitude` = '-95.305031' ,`PhotoCount` = '23' ,`PostalCode` = '77011' ,`RoomCount` = '5' ,`ListPrice` = '244000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue H' ,`StreetNumber` = '6717' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '0' ,`BathsHalf` = '5' ,`BedsTotal` = '5' ,`SqFtTotal` = '1804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location Location Location! 5 rental units on 90/Canal. Close to downtown, walking to light rail, major bank and supermarket. Fast growing. New construction 1 block away. Investor\'s dream income producing project.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 9 & 10 BLK 74 CENTRAL PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TIJERINA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'EDISON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Central Park' ,`TaxAmount` = '3427' ,`TaxRate` = '2.5716' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692177' WHERE `Matrix_Unique_ID` = '193074975' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:02:33.050' ,`MLSNumber` = '62657265' ,`ListAgentFullName` = 'Brianna Tieperman' ,`ListOfficeName` = 'Keller Williams Coastal Bend' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '28.065119' ,`Longitude` = '-97.101937' ,`PhotoCount` = '26' ,`PostalCode` = '78382' ,`RoomCount` = '6' ,`ListPrice` = '504000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dove Dr' ,`StreetNumber` = '111' ,`StreetSuffix` = '' ,`City` = 'Rockport' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Salt Lake Living! You have got to see the views from every angle of this wrap around porch. Gorgeous three bedroom, three bathroom, 2200 sq ft stilt home. Upstairs features a spacious living area with sit down bar connecting to the kitchen. Formal dining room will fit the entire family or perfect for entertaining guests. Master bedroom off of the living room with access to the wraparound porch. Bedroom two and three off of the kitchen with a spare guest bathroom and walk-in pantry/laundry room. Downstairs features a fully enclosed workshop, garage, storage shed; plenty of room for all the boats and tools. Sitting on three lots with a gorgeous pergola out back. Copano Cove is the place to call home. Come view this gorgeous home today!' ,`Acres` = '0.57' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Copano Cove Unit 7, lots 93, 94, 95' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '25200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '310 - Aransas County' ,`SchoolElementary` = 'LIVE OAK 1-3 LEARNING CENTER' ,`SchoolHigh` = 'ROCKPORT-FULTON HIGH SCHOOL' ,`SchoolMiddle` = 'ROCKPORT-FULTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Copano Cove' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692177' WHERE `Matrix_Unique_ID` = '209731195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T06:49:05.070' ,`MLSNumber` = '80267403' ,`ListAgentFullName` = 'Remo Castillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801221' ,`Longitude` = '-95.309344' ,`PhotoCount` = '10' ,`PostalCode` = '77026' ,`RoomCount` = '8' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Kress' ,`StreetNumber` = '4503' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Big Discount for a Quick Sale !!!! Great Property provides best living with easy access to downtown and public transit. It has 3 comfortable bedrooms with a friendly open plan. Extra storage ( 17 X 17 ). It has a great in-law apartment. A large yard with plenty of space to entertain, & relax.' ,`Acres` = '0.2342' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 296 BLK 16 LIBERTY GARDENS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ISAACS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Gardens' ,`TaxAmount` = '2004' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667692177' WHERE `Matrix_Unique_ID` = '211141045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:54:59.467' ,`MLSNumber` = '73509398' ,`ListAgentFullName` = 'Allison Yancy' ,`ListOfficeName` = 'Compass RE Texas, LLC- Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395706' ,`Longitude` = '-95.648879' ,`PhotoCount` = '42' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'La Jolla' ,`StreetNumber` = '69' ,`StreetSuffix` = 'Circle' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated home located on 3/4 acre in the gated community of Del Lago Estates on Lake Conroe. This beautiful home offers the elbow room you have been searching for coupled with lake views and neighborhood boat launch. Recent updates include: concrete flooring on the main level, interior paint, fixtures, appliances, outdoor fans, back patio pergola, landscaping, vanity in the powder room, office door and fencing in the backyard. The kitchen is spacious with an electric cooktop in the granite island, tons of counter space, storage and walk-in pantry. The primary suite overlooks the lush backyard and has a fireplace, sitting area, en-suite bathroom with dual sinks, jetted tub, shower and walk-in closet. Upstairs boasts a huge game room with balcony access 3 guest bedrooms and a full bathroom. The neighborhood is ideal for taking a stroll and is close to area amenities, Historic Montgomery, IAH and The Woodlands. Come and live where you love to play! Montgomery ISD.' ,`Acres` = '0.7343' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S401400 - DEL LAGO ESTATES, LOT 69' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '31986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Lago Estates' ,`TaxAmount` = '8707' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692178' WHERE `Matrix_Unique_ID` = '211861676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:22:46.857' ,`MLSNumber` = '4509218' ,`ListAgentFullName` = 'Michael Callihan' ,`ListOfficeName` = 'Riverway Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.786115' ,`Longitude` = '-95.440195' ,`PhotoCount` = '19' ,`PostalCode` = '77055' ,`RoomCount` = '4' ,`ListPrice` = '785000.00' ,`Status` = 'Active' ,`StreetName` = 'Dorset cliff' ,`StreetNumber` = '3505' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2709' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FIRST FLOOR LIVING! Built by Riverway Homes. Home is ready for move in! This residence offers 2709 sf of living space on 3 floors. Perfect for families with teenagers, live-in help or multi-generational family homes (En Suite 3rd floor Game Room/Optional living area). Patio sized lot offers green space and quaint covered courtyard-like area.' ,`Acres` = '0.0495' ,`Area` = '9' ,`BuilderName` = 'Riverway Properties' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2585' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Somerset Green' ,`TaxAmount` = '' ,`TaxRate` = '2.6161' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667692178' WHERE `Matrix_Unique_ID` = '212158461' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T06:16:55.267' ,`MLSNumber` = '72949629' ,`ListAgentFullName` = 'Jared Fikes' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Karlie Jacobs' ,`SellingOfficeName` = 'Great Western Realty' ,`Latitude` = '30.080974' ,`Longitude` = '-95.389501' ,`PhotoCount` = '32' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '282400.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Winding Willow' ,`StreetNumber` = '25407' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional home with stunning curb appeal! Entering through the front door, your eyes are immediately drawn to the gorgeous staircase & balcony that flows into the spacious living room with high ceilings. Directly off the living room, the beautiful updated kitchen boast granite counter tops, a perfectly situated island, stainless steel appliances & plenty of natural light. Dining room is perfectly located off the kitchen & offers ample space to enjoy meals with family and friends. Roomy primary bedroom is on the first floor and located off the kitchen. Updated primary bath offers a striking granite double sink countertop & remodeled shower. The sizable upstairs game room provides the ideal place for family entertainment. Other two bedrooms are located upstairs. The back yard paradise boast an exquisite pool & hot tub, a covered deck area and backs up to a preserve. New floors in most areas of home. Community amenities include a pool, tennis courts, and clubhouse. Won\'t last long!' ,`Acres` = '0.1697' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 21 LEXINGTON WOODS SEC 5' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7392' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Woods Sec 05' ,`TaxAmount` = '4010' ,`TaxRate` = '2.2769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692178' WHERE `Matrix_Unique_ID` = '213104931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:27:56.053' ,`MLSNumber` = '77287358' ,`ListAgentFullName` = 'Carlotta Matejka-Kaldor' ,`ListOfficeName` = 'The Kaldor Group' ,`SellingAgentFullName` = 'Jessica Perez' ,`SellingOfficeName` = 'Oakmont & Associates, LLC' ,`Latitude` = '29.562058' ,`Longitude` = '-95.333650' ,`PhotoCount` = '41' ,`PostalCode` = '77581' ,`RoomCount` = '12' ,`ListPrice` = '374500.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Quiet Arbor' ,`StreetNumber` = '2519' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2389' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Honey STOP the car! THIS IS THE ONE. Low tax rate. We can be home for the holidays in this perfect floor plan by Plantation Homes. Split floor plan with media room. 4/2/2 all brick. Well maintained. Interior painted 10/22. Walk into the extended tile entry with 2 decorative niches, 3 secondary bedrooms, bath & utility to the left. On the right there is a formal dining area with wood flooring that extends to the open concept family room with fireplace & perfect TV wall. Kitchen has granite and stainless steel appliances, breakfast island & breakfast area. Off the family room to the right is the media room, perfect for office, play area, but built as a media room by builder. To the back right of the family room is the primary bedroom with a window seat, large primary bath with long vanity, dual sinks and seperate tub & shower. Front & back doors are glass storm doors. Backyard has a covered patio with additional concrete for relaxing or hosting parties. Exclusions in Agent remarks.' ,`Acres` = '0.1584' ,`Area` = '5' ,`BuilderName` = 'Plantation' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON TERRACE SEC 3 (A0505 H T & B) BLK 3 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon Terrace Sec 3' ,`TaxAmount` = '8245' ,`TaxRate` = '2.6537' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692178' WHERE `Matrix_Unique_ID` = '213202200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:50:13.403' ,`MLSNumber` = '55103226' ,`ListAgentFullName` = 'Mufutau Adewunmi' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = 'Tracy Gremillion' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.974612' ,`Longitude` = '-95.531045' ,`PhotoCount` = '32' ,`PostalCode` = '77069' ,`RoomCount` = '10' ,`ListPrice` = '375000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pebble Beach' ,`StreetNumber` = '6623' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2882' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO A GORGEOUS HOME AND IS READY FOR NEW OWNERS. THIS HOME IS 4 BEDROOMS & 2.5 BATHROOMS .THIS HOUSE HAS BEEN UPDATED WITH A COMPLETE REMODEL NEW KITCHEN WITH CUSTOM BUILT CABINETS & LARGE KITCHEN ISLAND OPEN TO LIVING ROOM. THE ROOF, HVAC SYSTEM, ELECTRICAL BOX WERE INSTALLED 5 YEARS AGO, APPLIANCES, GRANITE COUNTER TOP, CARPET AND THE WHOLE HOUSE HAS BEEN REPIPED WITH PEX MATERIALS. THE SPACIOUS SUN ROOM YIELDS A REMARKABLE VIEW OF THE LARGE BACKYARD. THIS HOUSE HAS BEEN APPRAISED AND SELLER IS SELLING BELOW THE APPRAISED VALUE BECAUSE HE IS RELOCATING TO ANOTHER STATE. THIS IS A HUGE ADVANTAGE FOR A BUYER LOOKING FOR A HOUSE THAT HAS LOTS OF EQUITY. TAKE A HUGE ADVANTAGE OF THESE BENEFITS TO COME AND BUY THIS HOUSE NOW. ROOM DIMENSIONS ARE ESTIMATES AND PLEASE VERIFY. 1 HOUR NOTICE AND APPOINTMENT IS REQUIRED.' ,`Acres` = '0.233' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 158B & 159A BLK 8 CHAMPIONS WEST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions West' ,`TaxAmount` = '6347' ,`TaxRate` = '2.4906' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692179' WHERE `Matrix_Unique_ID` = '213349591' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:55:33.333' ,`MLSNumber` = '92624733' ,`ListAgentFullName` = 'Aholivama Martinez' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.882492' ,`Longitude` = '-95.137708' ,`PhotoCount` = '26' ,`PostalCode` = '77044' ,`RoomCount` = '4' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Jayhawk' ,`StreetNumber` = '11510' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to This mini Mansion a Builders Home. 4 Bedrooms and Game Room with a Wet Bar - 4 Bathrooms - 3 Car Garage with Extra 2 carports, enormous Back Yard 1.5 Acre with NO RESTRICTIONS .room dimensions independently verified by Buyer and Buyers Agent.' ,`Acres` = '1.3851' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 K-LAKE TERRACE U/R ABST 231 J DUNMAN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '60336' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Shorewood Add' ,`TaxAmount` = '7219' ,`TaxRate` = '2.2893' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667692179' WHERE `Matrix_Unique_ID` = '213509457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:41:09.057' ,`MLSNumber` = '38216155' ,`ListAgentFullName` = 'Derek Boles' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.039770' ,`Longitude` = '-95.338880' ,`PhotoCount` = '32' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Yorkgate' ,`StreetNumber` = '5926' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tenant Occupied - New Price! Finally a home that has it all. This gem is nestled in a great community near local freeways on a great sized lot. Property sits within 1 mile of golf course & comes with a BRAND NEW ROOF!!! - Well maintained yard as you approach this fully renovated home. New front door, new interior and exterior paint, new flooring and brand new custom kitchen. Large open floorplan from living room to kitchen. The primary retreat is a great size and comes with a brand new restroom with double vanity and large shower! There are too many upgrades to list. But you will love at first sight. See you soon!' ,`Acres` = '0.168' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 13 GREENGATE PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greengate Place Sec 02' ,`TaxAmount` = '3745' ,`TaxRate` = '2.6867' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692179' WHERE `Matrix_Unique_ID` = '213625293' --> 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','213643790','1667692179','213643790','2022-11-05T06:14:27.400','23497013','Munazah Monir','Texas United Realty','','','29.898229','-95.710376','15','77433','7','499500.00','Active','Stanton Lake','19822','Drive','Cypress','3','1','5','3960','Single-Family','Minutes from 290, closely located to Premium outlets, Easy access to I- 10 & Highway 6, also easy access to HWY 99.\r\n House has tons of upgrades, high ceilings, crown moldings, both formals, wood floors, rooms are bright and spacious and much more. Drapes are included with the sale . Some furniture can be sold and is negotiable . Custom chandeliers in the formal areas could be negotiated in the sale .It is a man guarded community with 24/7 on site security .\r\nThis particular house is 4 houses down from the community club house , park & gym . The community gives you access to Miramesa & Bridge creek club house , gym ,pool,splash pad and all the amenities associated with these 3 communities.','0.2339','25','','','','','Mud,Sellers Disclosure','1','','','Cypress South','Central Electric','1','LT 10 BLK 4 GATES AT CANYON LAKES WEST SEC 1','Water View','10190','Appraisal District','','1230','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','ANDRE ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Gates/Canyon Lakes West Sec 1','11122','3.041','Water District','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:02:33.830' ,`MLSNumber` = '86941990' ,`ListAgentFullName` = 'Mark Coyle' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.280760' ,`Longitude` = '-94.878348' ,`PhotoCount` = '39' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Teichman' ,`StreetNumber` = '9618' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1413' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION - WATERVIEW Come and see this 3 Bedroom 3 Bath two story home with a spectacular view of Galveston West Bay and Offit\'s Bayou. AE Flood Zone & No HOA. Watch the sunsets from your primary bedroom and either of the two huge decks. The primary bedroom has his/her closets an en-suite bathroom dual vanity and a jumbo shower with custom tiles. The home is supported with 16\" concrete, wood floors throughout, 9\' ceilings, new appliances, gas stove. The homes come\'s with a washer & Dryer on-demand hot water heater 4 ton -Rheem HVAC, Showcase impact windows & doors, Ceiling fans throughout the house, along with LED lighting. Great locating with easy access to HWY 45. Not to mention numerous marinas, boat ramps, fishing and bait stores nearby.' ,`Acres` = '0.0845' ,`Area` = '33' ,`BuilderName` = 'Martech' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Teichman/Channelview Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 4 ROSE PARKER ADDN NO 3 (2007)' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '3681' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Trimble & Lindsey Sec 1' ,`TaxAmount` = '532' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667692179' WHERE `Matrix_Unique_ID` = '213796625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:06:58.257' ,`MLSNumber` = '60807988' ,`ListAgentFullName` = 'Hector Alpuing' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = 'Brent Borden' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '30.029765' ,`Longitude` = '-95.534238' ,`PhotoCount` = '44' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '319900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ralick' ,`StreetNumber` = '7502' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home on huge half acre lot in established Memorial Northwest Subdivision. Home boasts 4 bedrooms, 2.5 baths, 2 car garage and both formal dinning and living rooms. Upgrades include new roof, A/C, granite counter tops, stainless steel appliances, travertine backsplash, crown molding, and recently tiled 2nd floor walk out balcony to name a few. Zoned to highly desired Klein ISD and has a spectacular neighborhood community center, fitness room, tennis courts, splash pad & pool. NEVER FLOODED! Make your appointment today!' ,`Acres` = '0.5234' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 017*M1876900-001-001-003 MEMORIAL NORTHWEST SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '22800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '693' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Northwest Sec 01' ,`TaxAmount` = '5117' ,`TaxRate` = '2.3213' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692179' WHERE `Matrix_Unique_ID` = '213877914' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:54:06.757' ,`MLSNumber` = '43050857' ,`ListAgentFullName` = 'Michael Tepera' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.744861' ,`Longitude` = '-95.405959' ,`PhotoCount` = '22' ,`PostalCode` = '77019' ,`RoomCount` = '10' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairview' ,`StreetNumber` = '1938' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional three-story free-standing home in upscale River Oaks/Montrose neighborhood of single-family homes and tree-lined streets. Super central yet secure and quiet. Variety of both upscale and casual dining, entertainment, and shopping nearby, much in walking distance. Just a quick drive to major areas of interest like Downtown, Medical Center, Buffalo Bayou Park, and Galleria, and easy access to highways I-59, I-10, and I-45. No HOA. Would make a fine home or investment property. Two spacious top story bedrooms with en suite bathrooms plus a private first story guest bedroom with backyard access and adjacent bathroom. Large, light filled living room and dining area with fireplace, plus spacious kitchen, breakfast nook, and utility room on middle floor. Two HVACs recently installed w/smart thermostats and air purifying system. Security includes anti-kick-in locks and security system. Home had only one owner, and never flooded.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Shopping Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 7B BLK 13 PLAINVIEW SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '1342' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Plainview Add 02' ,`TaxAmount` = '8845' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692180' WHERE `Matrix_Unique_ID` = '213981325' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:07:00.660' ,`MLSNumber` = '54023700' ,`ListAgentFullName` = 'Susan Hutson' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = 'Adepeju Bakrin' ,`SellingOfficeName` = 'ERA Legacy Living' ,`Latitude` = '29.764243' ,`Longitude` = '-95.833810' ,`PhotoCount` = '44' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '514000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rustic Woods' ,`StreetNumber` = '26242' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 story home has 2 Bedrooms downstairs located in the beautiful Woodcreek Reserve Community w no neighbors in the back! As you enter this beautiful home you are greeted w soaring two story ceilings & gorgeous engineered wood flooring throughout the common areas on the first floor! This home features a private study also w wood flooring & behind glass plated french doors, elegant formal dining room w crown molding. Large kitchen w granite counters, undermount sink, stainless appliances, gas range cooktop. Huge living room space again w high ceiling & wood flooring. Large primary bathroom w granite counters, double sinks, jetted tub, & huge walk in closet. Secondary inlaw suite downstairs great for guest to stay. Three large secondary bedrooms on the second floor w great sized closet space. Media & gameroom also on the second floor, this home is perfect for entertaining. This amazing home is about 2 blocks away from Woodcreek Elementary & Woodcreek JH easy access to I10!' ,`Acres` = '0.2324' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODCREEK RESERVE SEC 8, BLOCK 1, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodcreek Reserve Sec 8' ,`TaxAmount` = '10415' ,`TaxRate` = '2.8317' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692180' WHERE `Matrix_Unique_ID` = '214075569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:41:39.880' ,`MLSNumber` = '61544214' ,`ListAgentFullName` = 'Eugene Chua' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.216644' ,`Longitude` = '-95.429120' ,`PhotoCount` = '47' ,`PostalCode` = '77385' ,`RoomCount` = '11' ,`ListPrice` = '337000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenhouse' ,`StreetNumber` = '16789' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A grand opportunity awaits in Montgomery Creek Ranch! Enjoy this 5-bed/ 3-bath home just 30 minutes from Lake Conroe! Move-in-ready, you\'ll love the abundance of natural light that illuminates this clever floor plan. Highlights include a bedroom ensuite on the 1st floor and tons of updates throughout! Delight in new floors, new granite countertops, and new stainless steel kitchen appliances including a refrigerator! You\'ll also find new light fixtures, new blinds, new toilets, and even a new garage door! Relax by the fireplace in your spacious family room. Adjacent to the dining room and kitchen, the beautiful tile floors connect the rooms seamlessly. All bedrooms offer wood-like vinyl flooring including the 1st-floor ensuite, perfect for a guest room or study. The 2nd floor reveals a study area and 4 bedrooms including the primary suite. Enjoy a huge backyard with a new concrete patio. Only minutes from restaurants, stores, and the hospital, you can\'t go wrong. Come see for yourself!' ,`Acres` = '0.1211' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S720808 - MONTGOMERY CREEK RANCH 08, BLOCK 7, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5275' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 08' ,`TaxAmount` = '6203' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692180' WHERE `Matrix_Unique_ID` = '214081546' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:47:57.623' ,`MLSNumber` = '80763647' ,`ListAgentFullName` = 'Ashley Alexander' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.867921' ,`Longitude` = '-95.368896' ,`PhotoCount` = '19' ,`PostalCode` = '77076' ,`RoomCount` = '3' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Mcgallion' ,`StreetNumber` = '11513' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1194' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! This is the perfect starter home, ready for move in when you are. Location is a huge bonus being less than a minute away from the Hardy Toll Way, and less than 5 minutes from both I45 & I59. Let\'s talk about the amazing interior with a modern finish, and the exterior being the entertainers dream! Covered patios in the front and back of the home, along with a one car detached garage in the backyard. There are many possibilities here by either converting the garage to a garage apartment or adding to the home, remember no HOA means no asking for permission. Roof is roughly 12 years old, HVAC system is roughly 5 years old.' ,`Acres` = '0.1779' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1133 BLK 60 HAWTHORNE PLACE SEC 9' ,`LotDesciption` = 'Other' ,`LotSize` = '7750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BARRICK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'PATRICK HENRY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hawthorne Place Sec 09' ,`TaxAmount` = '1984' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692180' WHERE `Matrix_Unique_ID` = '214196795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:35:40.390' ,`MLSNumber` = '18593469' ,`ListAgentFullName` = 'Cecilia Hernandez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062593' ,`Longitude` = '-95.717059' ,`PhotoCount` = '25' ,`PostalCode` = '77377' ,`RoomCount` = '7' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Avelignese' ,`StreetNumber` = '20435' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enter this PERRY HOME with 12-foot ceilings at the entrance. You will be greeted by a spacious Game room with French doors upon entering this gorgeous home. Enjoy a open concept family room that extends to the dining area. The spacious family room with a wood mantel fireplace has a wall of large windows looking out to the back covered patio. The open kitchen offers and island with built-in seating space and a corner walk-in pantry. The Primary suite also has a wall of windows. The primary bath has dual vanities, a garden tub, separate glass enclosed shower and two spacious walk-in closets. The Guest suite just off the extended entry has a full bathroom and walk-in closet. Secondary bedrooms also have walk-in closets. The utility room offers private access to the primary bathroom. The Mud room is perfectly situated near the two-car garage. Schedule your tour of this beautiful home today!' ,`Acres` = '0.1549' ,`Area` = '35' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Blk 1 Amira Sec 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '8682' ,`TaxRate` = '3.56' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692181' WHERE `Matrix_Unique_ID` = '214279419' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:27:46.430' ,`MLSNumber` = '80425228' ,`ListAgentFullName` = 'Star Massing' ,`ListOfficeName` = 'Boulevard Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806241' ,`Longitude` = '-95.392464' ,`PhotoCount` = '40' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '1075000.00' ,`Status` = 'Active' ,`StreetName` = 'Oxford' ,`StreetNumber` = '2203' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificent, thoughtfully-designed custom home on a corner lot just a stone’s throw away from Heights Blvd. jogging trail and beloved local shops & restaurants along 19th. Great attention to detail shines through every inch of this Heights home, from the Carrara marble counters (throughout) to the custom mosaic tile floors. Southern charm emanates from the majestic exterior while modern functionality reigns supreme inside with an open, free flowing floor plan and en suite baths for all bedrooms. Kitchen is an ideal blend of beauty and function, boasting high-end SS appliances (including Bertazzoni gas range), gorgeous subway tile backsplash, and large walk-in pantry. 10 ft ceilings, reclaimed solid oak floors, screened front porch, pristine landscaping, a surplus of storage, attached 2-car garage with workbench, and exceptional laundry/mudroom are among the many other highlights. Enjoy having local faves like Chilosos, Lei Low, The Post, and 14 Pews all within a few blocks.' ,`Acres` = '0.0758' ,`Area` = '9' ,`BuilderName` = 'Michalson' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 HOUSTON HEIGHTS 9TH PAR R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '3300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights Pt Rep 9' ,`TaxAmount` = '17444' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692181' WHERE `Matrix_Unique_ID` = '214289988' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T07:30:28.913' ,`MLSNumber` = '48451354' ,`ListAgentFullName` = 'Gregg Engle' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795358' ,`Longitude` = '-95.430839' ,`PhotoCount` = '28' ,`PostalCode` = '77008' ,`RoomCount` = '6' ,`ListPrice` = '477000.00' ,`Status` = 'Active' ,`StreetName` = 'Cindy' ,`StreetNumber` = '6515' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'No showings until 1st open house Sun. 11/6 2pm - 4pm. 6515 Cindy Lane is located in the coveted middle section of Timbergrove Manor with a great front yard and curb appeal! Inside, gorgeous hardwoods cover all the floors except for tile in the kitchen and baths. Laid out in ranch style, the living room on the right is open to the Kitchen and dining areas. Down the hallway to the left are the baths, office space, 2 nice size secondary bedrooms, and a sweepingly large primary. The backyard is big enough for a room addition plus a pool, garden, outdoor kitchen, or all the above! The 2-car garage has space for extra storage or a small workshop. Jaycee Park & TC Jester hike/bike trails are just blocks away and even closer is the 5-Star, Excellent Rated Sinclair elementary school. 3 minutes to I-10, 610 or 290 to get where you are going FAST! Ready for your cosmetic changes and that new kitchen you have always wanted! NOT IN A FLOOD ZONE and never flooded per seller.' ,`Acres` = '0.2014' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 47 TIMBERGROVE MANOR SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8775' ,`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` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Other Style,Ranch,Traditional' ,`Subdivision` = 'Timbergrove Manor' ,`TaxAmount` = '9692' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667692181' WHERE `Matrix_Unique_ID` = '214398483' --> Updated record success