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` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '34815713' ,`ListAgentFullName` = 'Maria Pulido' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.071908' ,`Longitude` = '-95.125896' ,`PhotoCount` = '49' ,`PostalCode` = '77541' ,`RoomCount` = '8' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado' ,`StreetNumber` = '12926' ,`StreetSuffix` = 'Drive' ,`City` = 'Freeport' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*$5K credit offered to buy down your interest rate and other help from the sellers* Enjoy this beautiful decorated New Construction fully furnished custom beach house with 4 Beds and 4.5 Baths in Treasure Island. Incredible decks with beach and bay views to entertain and watch sunsets from the balconies. Ideally located next to the beach. Upon entry you are greeted with large guests bedrooms each with their own private ensuite, enjoy the natural light in the stunning primary bedroom with walk-in closet and well appointed bath. Second floor appeal with main living that flows seamlessly with sunlit entry, chef\'s kitchen open the spacious living and dining area. Waterproof laminate floors, quartz countertops, large center island with added seating. All custom touches throughout adorn this home, making it a warm, inviting and unique. This home could serve as a primary residence with plenty of flexible spaces for working at home.' ,`Acres` = '0.1148' ,`Area` = '5' ,`BuilderName` = 'Cena Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Treasure Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TREASURE ISLAND (A0029 S F AUSTIN), BLOCK 14, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '10' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Treasure Island' ,`TaxAmount` = '844' ,`TaxRate` = '2.3804' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216902' WHERE `Matrix_Unique_ID` = '206376282' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '44480406' ,`ListAgentFullName` = 'Afzaal Rizvi' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.626602' ,`Longitude` = '-95.676483' ,`PhotoCount` = '49' ,`PostalCode` = '77498' ,`RoomCount` = '8' ,`ListPrice` = '514900.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Creek' ,`StreetNumber` = '13111' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully renovated beautiful home in Orchard Lake. Brand new appliances Oven, Microwave, Dishwasher, Garbage disposable, updated plumbing, new wooden floor, new sprinkler system, new fresh paint inside and outside of the house, new garage door opener and updated landscaping. Spacious floor plan in the gated community of Orchard Lake Estates. Upon entering the home, the high ceilings and gorgeous dark wood floors welcome you into a formal dining room and formal living room that can also be used as a home office/study. The tall ceilings continue into the family room featuring a fireplace and a wall of windows with blinds. This is truly a home for the family with the open concept kitchen with plenty of cabinets, granite countertops with center island and stainless steel appliances. The primary bedroom and bathroom is located on the first floor and features an oversized walk-in closet. 2 full bathrooms and a game room on 2nd floor. This home is a must see in this beautiful community.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ORCHARD LAKE ESTATES SEC 1, BLOCK 7, LOT 40, 50.000000% UDI' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OYSTER CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Orchard Lake Estates' ,`TaxAmount` = '4280' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216902' WHERE `Matrix_Unique_ID` = '208024971' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '59200906' ,`ListAgentFullName` = 'Antonio Rodriguez' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.746516' ,`Longitude` = '-95.321592' ,`PhotoCount` = '28' ,`PostalCode` = '77011' ,`RoomCount` = '7' ,`ListPrice` = '409990.00' ,`Status` = 'Active' ,`StreetName` = 'Engel' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Contemporary/Modern new construction in Super 2nd Ward with a backyard! This modern Townhome includes 3 bedrooms and 2.5 bathrooms. The open floor plan features high ceilings, huge windows, a stunning kitchen with a large island and pantry, dining area, living room pre-wired for surround sound, and a conveniently located half bathroom. Beautiful Granite counter tops as well as soft closing cabinets and drawers throughout the home and bathrooms. Tile Hardwood floors on the first floor hard wood floors carry up the stairs through the second floor, modern tile selections in the full bathrooms. The spacious Master Suite is located on the second floor which includes dual vanities plus a huge walk in closet! Secondary bedrooms, full bathroom, and utility room are also located on the second floor. DONT FORGET TO CLICK ON THE VIDEO AND VIRTUAL WALK THRU' ,`Acres` = '0.2296' ,`Area` = '4' ,`BuilderName` = 'Villareal Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 3 & 4 BLK 2 ENGEL' ,`LotDesciption` = 'Corner' ,`LotSize` = '2500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Engel' ,`TaxAmount` = '3752' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216902' WHERE `Matrix_Unique_ID` = '209233517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '37965436' ,`ListAgentFullName` = 'Antonio Rodriguez' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.746516' ,`Longitude` = '-95.321592' ,`PhotoCount` = '26' ,`PostalCode` = '77011' ,`RoomCount` = '7' ,`ListPrice` = '409900.00' ,`Status` = 'Active' ,`StreetName` = 'Canal' ,`StreetNumber` = '5209' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Contemporary/Modern new construction in Super 2nd Ward with a backyard! This modern Townhome includes 3 bedrooms and 2.5 bathrooms. The open floor plan features high ceilings, huge windows, a stunning kitchen with a large island and pantry, dining area, living room pre-wired for surround sound, and a conveniently located half bathroom. Beautiful Granite counter tops as well as soft closing cabinets and drawers throughout the home and bathrooms. Tile Hardwood floors on the first floor hard wood floors carry up the stairs through the second floor, modern tile selections in the full bathrooms. The spacious Master Suite is located on the second floor which includes dual vanities plus a huge walk in closet! Secondary bedrooms, full bathroom, and utility room are also located on the second floor. DONT FORGET TO CLICK ON THE VIDEO AND VIRTUAL WALK THRU' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'JJ Villareal LLC.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'lot 2 blk 2 section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Canal project' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216902' WHERE `Matrix_Unique_ID` = '209346776' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '39445722' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.433451' ,`Longitude` = '-95.450781' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '317990.00' ,`Status` = 'Active' ,`StreetName` = 'Greenhorn' ,`StreetNumber` = '10334' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 4 Bedroom, 2 Bath, Study with French Doors, Formal Dining, Dual Vanities in Primary Bath, Separate Garden Tub and 1/2 Glass Wall Shower, Rigid Core Floors in Entry/Foyer, Study, Dining, Kitchen, Family Room and All Baths, Recessed Tile Shower in Primary Bath, Granite Kitchen Countertops with Island, Granite Bathroom Tops with Square Sinks, Mosaic Tile Backsplash, 42” Upper Kitchen Cabinets, Stainless Steel Appliances, Stone Accents, 2” Window Blinds, Upgraded Lighting & Plumbing Packages, Rocker Switches, Brick Back, Covered Patio, Full Sod and Irrigation System, Full Gutters, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE DECEMBER.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 14 BLK 1 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8059' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216903' WHERE `Matrix_Unique_ID` = '210066397' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '21309046' ,`ListAgentFullName` = 'Sue Johnson' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.224279' ,`Longitude` = '-94.919589' ,`PhotoCount` = '35' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Madrid' ,`StreetNumber` = '12840' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A picturesque 3 bed 2 bath home, greets you with a Canary yellow door, located perfectly on a corner canal lot, in the ever so quiet Spanish Grant subdivision. Enter upon the spacious foyer as you make your way upstairs to the main area of the home, where the layout is perfectly fit to enjoy family with its open living/kitchen/dining concept. Enjoy the living space, wired for sound & overlooking the spacious patio or cook your favorite meals in the tucked away kitchen with stainless steel appliances & vast cabinetry space. Spacious primary with separate ensuite & guest bedrooms can be found just down the hall, off kitchen area. From interior to exterior, this home does not fall short on space from the large fully fenced in yard with boat house to the Gameroom, equipped with wet bar & tons of space for entertaining, just off the lovely, covered patio & 2-car garage! Furniture to convey with sale. \"Man/Woman Cave\" on ground level.' ,`Acres` = '0.1747' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 53 LOT 84 SPANISH GRANT' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '7610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '80' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Spanish Grant 1' ,`TaxAmount` = '8954' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216903' WHERE `Matrix_Unique_ID` = '210082216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '47438612' ,`ListAgentFullName` = 'John Newsom' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727271' ,`Longitude` = '-95.827706' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '13' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Juniper Forest Fall' ,`StreetNumber` = '26618' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '4151' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Almost new. New kitchen appliances, new carpet, fresh paint inside, new front door, new cabinet fronts. Has that new home smell. Large open area kitchen, breakfast and family room, great for and those that want to entertain. Primary closet is large walk in. Secondary bedroom on first floor with full bath. 4 bedrooms upstairs with a gameroom and media/computer gaming room. Notice on aerial how close the home is to the splash pad. Walking distance' ,`Acres` = '0.1516' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'PINE MILL RANCH SEC 5, BLOCK 1, LOT 15' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '6603' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KEIKO DAVIDSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'TAYS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Pine Mill Ranch Sec 5' ,`TaxAmount` = '9072' ,`TaxRate` = '2.7845' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216903' WHERE `Matrix_Unique_ID` = '210156552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '10618598' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223953' ,`Longitude` = '-95.778843' ,`PhotoCount` = '42' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '374915.00' ,`Status` = 'Active' ,`StreetName` = 'Mystical Bend' ,`StreetNumber` = '42036' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1921' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the quaint community of Escondido, this spectacular home offers something for everyone. Step inside and discover all the exquisite designer grade selections that make this home unique. Entering through the elongated foyer, you will pass 3 bedrooms. Luxury vinyl plank paves your way throughout the main living areas of the home. The lovely kitchen features 42\" cabinetry, granite countertops, and stainless-steel appliances. The primary suite boasts a spa-like primary bath that hosts a garden tub, separate shower with seat, and an over-sized closet. After a long day, escape to the large covered patio. This home is certified Environments for Living and offers some of the highest energy features available today.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6120' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Escondido' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216903' WHERE `Matrix_Unique_ID` = '211422534' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '74286801' ,`ListAgentFullName` = 'Britni Haley' ,`ListOfficeName` = 'Gulf Coast Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.944993' ,`Longitude` = '-95.298031' ,`PhotoCount` = '26' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Texas' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Street' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beach cottage will make the perfect primary home, investment property, or vacation getaway! Take your vision and make it a reality, priced with interior updates in mind! It has great indoor and outdoor living spaces to enjoy after a long day at the beach. The expanded deck gives you plenty of room to spread out and soak up the views of the Gulf, the large ships coming into port, stunning sunsets over the intracoastal, wetlands full of wildlife, and the Surfside bridge. This quiet part of the village offers tranquil beachside living with a short walk to the beach, boat ramp, jetty park, Ft. Velasco museum, bird & butterfly trail, splash pad, restaurants, and more!! Enter from the deck to the open living area. The primary suite is to the right of the living room, while the guest bedroom and bathroom are to the left. Currently occupied, so be sure to call ahead.' ,`Acres` = '0.1478' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE BLK 550 LOT 9 (A0051 F J CALVIT)' ,`LotDesciption` = 'Water View' ,`LotSize` = '6438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside' ,`TaxAmount` = '2399' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216903' WHERE `Matrix_Unique_ID` = '211659600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '69526386' ,`ListAgentFullName` = 'Lorrie Parker' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.027518' ,`Longitude` = '-95.409919' ,`PhotoCount` = '36' ,`PostalCode` = '77073' ,`RoomCount` = '15' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodchurch' ,`StreetNumber` = '1231' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3027' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charm and Character are the best ways to describe this traditional home. Formal foyer leads to the sophisticated living and dining rooms. Large kitchen with a breakfast bar for impromptu meals or buffet serving. Inviting Den has full brick wood-burning fireplace to enjoy with company. With 2 bedrooms down, all the bedrooms are spacious and all have walk-in closets. The large upstairs room is great for a game or media room and centralized to the other 3 bedrooms. The luscious greenery of the fenced-in backyard and covered patio make the afternoons perfect for an entertaining time. The three-car garage gives plenty of space for the handyman with projects. With a little imagination and love, your dream home can be a reality!' ,`Acres` = '0.303' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Inverness Forest Sec 01 Block 2 Lot 45' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '13200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'LEWIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inverness Forest' ,`TaxAmount` = '5172' ,`TaxRate` = '2.5234' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216904' WHERE `Matrix_Unique_ID` = '211846766' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '28888471' ,`ListAgentFullName` = 'Anne Hettiger' ,`ListOfficeName` = 'Segue Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066449' ,`Longitude` = '-95.494460' ,`PhotoCount` = '31' ,`PostalCode` = '77388' ,`RoomCount` = '9' ,`ListPrice` = '297500.00' ,`Status` = 'Active' ,`StreetName` = 'Hennington' ,`StreetNumber` = '4907' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2623' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully Remodeled 4/2.5 Home On Quiet Street. Located A Few Blocks From The Elementary School, Makes Commuting A Breeze. Minutes From Shopping, Restaurants And Very Convenient To I-45. Open Kitchen With Breakfast Area Is Perfect For Morning Conversations And Coffee. The Master Bedroom Downstairs Offers The Ultimate Private Retreat In Split Floor Plan With Private Ensuite. Combination Formal Living And Dining Area With Gorgeous Tile Offers An Open Concept Floor Plan That\'s Perfect For Entertaining And Includes Wet Bar. Cozy Fireplace Adds A Warm, Inviting Feel. Upstairs Has A Huge 4th Bedroom That Could Be A GameRoom, 2nd Master, The Possibilities Are Endless. Home Features: New Paint, Roof, Granite Countertops And Carpet,Fresh Paint Inside And Out, All New Appliances, Recent Flooring And Fixtures Throughout. Guest Bedrooms Are A Great Size And Will Keep Your Guests Comfortable. Large Fenced In Backyard Features A Huge Covered Deck To Entertain And Hang Out No Matter The Weather.' ,`Acres` = '0.1543' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 2 BRIDGESTONE SEC 4 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '327' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ROTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgestone R/P' ,`TaxAmount` = '5653' ,`TaxRate` = '2.644' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216904' WHERE `Matrix_Unique_ID` = '212084739' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '24287130' ,`ListAgentFullName` = 'Jackie Greer' ,`ListOfficeName` = 'Berkshire Hathaway HomeService' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.300492' ,`Longitude` = '-94.906581' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Admiral' ,`StreetNumber` = '306' ,`StreetSuffix` = 'Circle' ,`City` = 'Tiki Island' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 bedroom 2 bath Tiki home, with an ELEVATOR. Hand scraped Teak floors in living and dining, tile kitchen and baths. Bathrooms totally updated, with quartz countertops, under counter sinks, glass shower doors and tile. Kitchen has granite countertops, brushed stainless steel refrigerator and dishwasher, and a stylish faucet. Downstairs elevator room is air conditioned/bonus room. There is an extra room off the living room that is being used as an office, could be used as exercise room or bunk room. Downstairs is great for entertaining, oversize garage with work bench area and lots of cabinet space. Replaced deck, dock, staircase and rails in 2019. Relax and take in the views from the covered porch on the upper deck. This home has been very well maintained with low flood insurance. A must see, call for appointment today!!' ,`Acres` = '0.114' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 15 LOT 15 BLK 1 TIKI YACHT CLUB COLONY' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '4966' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '10276' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216904' WHERE `Matrix_Unique_ID` = '212103089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '92776555' ,`ListAgentFullName` = 'Naila Duran' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688015' ,`Longitude` = '-95.299730' ,`PhotoCount` = '18' ,`PostalCode` = '77087' ,`RoomCount` = '6' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Mchenry' ,`StreetNumber` = '7221' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1324' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully Remodeled 4 bedroom home with updates such as an oversized porch, quartz countertops, wood look flooring, ceiling fans throughout & so much more! Fully fenced back yard for added privacy with easy access to Highway 45 & 610. Schedule your showing today!' ,`Acres` = '0.1492' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 22 GOLFCREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GOLFCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Golfcrest' ,`TaxAmount` = '2065' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1941' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216904' WHERE `Matrix_Unique_ID` = '212156686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '98550486' ,`ListAgentFullName` = 'Jenine Cinco' ,`ListOfficeName` = 'Kay Stimson Properties , LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.213283' ,`Longitude` = '-95.589607' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Bear Mountain' ,`StreetNumber` = '8907' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPGRADES GALORE and GENEROUS BACKYARD. Gorgeous 4 bedroom, 3.5 bath PLUS media and game room. 3,648 sqft, OVERSIZED, CUL DE SAC LOT, built in 2019. Brick and stone exterior with covered front porch and back patio. 2-story foyer with elegant ENGINEERED OAK WOOD floors. ABUNDANT NATURAL LIGHT and RAISED CEILINGS throughout. Open floor plan kitchen with GRANITE countertops, SS appliances, GAS cooktop and DOUBLE OVEN. Primary suite DOWN has expanded floor plan, oversized bath with double vanities, separate shower and soak tub. Second floor features a GUEST BEDROOM W/ ENSUITE BATH, 2 extra guest suites and a shared full bath. Media room plus a separate game room UP. Water softener, Sprinkler System, 3 min. drive to HEB, zoned to Magnolia ISD. Fully fenced backyard with room for pool. We cannot wait to see you! Schedule a preview today.' ,`Acres` = '0.226' ,`Area` = '15' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S341107 - CIMARRON CREEK 07, BLOCK 2, LOT 23' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9843' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Creek' ,`TaxAmount` = '6397' ,`TaxRate` = '3.1887' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216905' WHERE `Matrix_Unique_ID` = '212233068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '75763505' ,`ListAgentFullName` = 'Carlos Nava' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.756455' ,`Longitude` = '-95.382494' ,`PhotoCount` = '13' ,`PostalCode` = '77019' ,`RoomCount` = '6' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Robin' ,`StreetNumber` = '1510' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a great 3 bedroom 2 story house in the Historical 4th Ward. It has new flooring downstairs and up along with fresh paint in the bedrooms and new kitchen countertops and backsplash. With all the amenities surrounding the home, it\'s perfect for you and your family or as a rental investment. Those amenities are; dog park, playground, shops, bars, restaurants, 20 minutes from the Zoo and the Museum District, 8 minutes from Midtown, 9 minutes from Downtown, 6 minutes from Buffalo Bayou Park. There are big plans already in the works for 4th Ward.' ,`Acres` = '0.037' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 1 ANTIOCH COURTS AT DOWNTOWN SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GREGORY-LINCOLN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Antioch Courts/Downtown Sec 03' ,`TaxAmount` = '5523' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216905' WHERE `Matrix_Unique_ID` = '212277915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '53726877' ,`ListAgentFullName` = 'Azalia Benjamin-Mathis' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823212' ,`Longitude` = '-95.552303' ,`PhotoCount` = '44' ,`PostalCode` = '77043' ,`RoomCount` = '7' ,`ListPrice` = '597900.00' ,`Status` = 'Active' ,`StreetName` = 'Durban' ,`StreetNumber` = '2807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2435' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled on a quiet, cul-de-sac street with mature oak trees, you will find this Spring Shadows gem that rivals new construction! Complete renovation including NEW AC, NEW Water Heater, Re-paved driveway, PEX PLUMBING, and NEW electrical upgrades! The moment you enter, you will be amazed at the incredibly OPEN FLOOR PLAN and abundance of NATURAL LIGHT . Freshly painted walls, wide plank LVT and bright windows welcome you into the home. The kitchen is a chef\'s dream with ZLINE APPLIANCES, and QUARTZ counters. Find AMPLE STORAGE in CUSTOM white cabinets and full pantry! This entertainer\'s floor plan continues outside with a SPACIOUS covered patio, ready to host your next back yard BBQ. All bedrooms are CONVENIENTLY located upstairs. The primary suite is spacious and has ELEGANT DETAILS such as gold fixtures and free-standing tub. A unique feature of this floor plan is the primary suite connects to another bedroom-IDEAL for a nursery, office or home gym! Schedule your tour today!' ,`Acres` = '0.1768' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK W14 SPRING SHADOWS SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Spring Shadows Sec 10' ,`TaxAmount` = '9804' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216905' WHERE `Matrix_Unique_ID` = '212362037' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '24735394' ,`ListAgentFullName` = 'Ana Patricia Torres' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043077' ,`Longitude` = '-95.356670' ,`PhotoCount` = '21' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Banquo' ,`StreetNumber` = '22922' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful Home!!!\r\nYou\'ll love all the incredible features this home has to offer, including a gorgeous primary suite, spacious living room, granite countertops, open concept, 5th bedroom can be converted onto a game room, fully fenced backyard and nice back patio with storage unit in the back.' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 FAIRFAX VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6237' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfax Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216905' WHERE `Matrix_Unique_ID` = '212433392' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '33298814' ,`ListAgentFullName` = 'Grace Harris' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.401318' ,`Longitude` = '-95.552496' ,`PhotoCount` = '24' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Laura Lake' ,`StreetNumber` = '13034' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 1 Story Home in a lakeside community! Vinyl plank flooring throughout. Carpet in bedrooms only and tile floor in master bath. Open floor with oversized island kitchen and breakfast open to a family room with lots of windows, fabulous kitchen with granite counters, custom backsplash, undermount sink, stainless steel appliances, pantry and breakfast area with lots of windows. Master suite with high ceilings, master bath with double sinks, garden tub and separate shower w/big walk-in closet. Home also features a structured wiring panel for future technology, USB/Electrical combo plugs in kitchen and master bedroom, privacy fence backyard, covered patio and much more included in this home! Low Tax Rate! Willis ISD! Call today' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'KENDALL HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Clear View Estates, Block 1, Lot 18, Sec 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear View Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.5879' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216906' WHERE `Matrix_Unique_ID` = '212552005' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '13209911' ,`ListAgentFullName` = 'Grace Harris' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.401877' ,`Longitude` = '-95.553036' ,`PhotoCount` = '23' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Ondrea' ,`StreetNumber` = '11008' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bedroom 1 story home w/vinyl wood plank flooring throughout w/carpet in bedrooms only! Fabulous kitchen with stainless steel appliances, oversized serving bar, designer backsplash and breakfast area big enough for a table setting for 8! Open floor plan with oversized family room! Owners retreat with high ceilings and ensuite bath w/double sinks, garden tub and separate shower & w/big walk-in closet. Granite in the kitchen and silestone counters in both baths! Home features include USB/Plug combo in kitchen and master bedroom, covered patio and 6 foot privacy fence backyard and much more included in this home! Low Tax Rate! Willis ISD! Call today!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'KENDALL HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Clear View Estates Block 2, Lot 7, Sec 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6382' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear View Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216906' WHERE `Matrix_Unique_ID` = '212552320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '36937769' ,`ListAgentFullName` = 'Ashlee Cooper' ,`ListOfficeName` = 'Coldwell Banker RealtyThe Willis Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.300997' ,`Longitude` = '-95.312517' ,`PhotoCount` = '23' ,`PostalCode` = '77306' ,`RoomCount` = '5' ,`ListPrice` = '235900.00' ,`Status` = 'Active' ,`StreetName` = 'Briar Forest' ,`StreetNumber` = '15560' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this like-new home in Crockett Reserve! The home isn\'t even a year old yet! This 1-story 3 bedroom 2 bathroom home boasts an open concept dining area and living room with a beautiful kitchen featuring granite countertops, good storage space, and stainless steel appliances. The primary bedroom has an ensuite bath attached and nice size closets. The laundry room is located inside the home. Items added by the seller that the builder does not include in their new construction homes currently being built: backyard sod, a gutter system in the front and back of the home, extra cabinets in the kitchen area, 2 ceiling fans, towel rods in both bathrooms, shower curtain rods in both bathrooms, all new wood blinds in the home and much more! No back neighbors! MOTIVATED SELLER! BRING YOUR OFFERS!' ,`Acres` = '0.114' ,`Area` = '40' ,`BuilderName` = 'Century Complete' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S356300 - CROCKETT RESERVE 01, BLOCK 3, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4965' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'CREIGHTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crockett Reserve 01' ,`TaxAmount` = '275' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216906' WHERE `Matrix_Unique_ID` = '212579468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T01:22:33.347' ,`MLSNumber` = '61199483' ,`ListAgentFullName` = 'Lee Hudman' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752624' ,`Longitude` = '-95.391248' ,`PhotoCount` = '43' ,`PostalCode` = '77006' ,`RoomCount` = '6' ,`ListPrice` = '699999.00' ,`Status` = 'Active' ,`StreetName` = 'Peden' ,`StreetNumber` = '1012' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'English cottage style art deco jewel box on one of the best blocks in East Montrose. Featured twice on East Montrose Biennial Home Tour. High ceilings, art deco touches, vaulted living room w/ cloud ceiling & hidden lighting & WBFP, octagon shaped fir down dining room w/ cloud ceiling. Spacious den w/ surround sound & hidden storage. Large eat-in kitchen w/ lots of cabinets & counter space. Multiple glass pocket doors, incredible main bath w/ large spa tub. 25 windows, w/ most having blackout cellular up/down shades. Two large closets w/ storage & drawers in the main bedroom. Side deck & back screened-in porch. HVAC system & roof replaced in 2015. Tankless water heater. PEX piping. Hurricane film on windows & glass doors. Deco style wood floors or tile - no carpet! All appliances stay. Garage w/ 2nd story storage is sold as is. Mostly fresh interior neutral paint. Oversized lot! Plus more features and location location location!' ,`Acres` = '0.1429' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription`