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-13T19:07:01.013' ,`MLSNumber` = '67694603' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220883' ,`Longitude` = '-95.712402' ,`PhotoCount` = '5' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '624900.00' ,`Status` = 'Active' ,`StreetName` = 'Ringbill' ,`StreetNumber` = '15476' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perry Homes New Construction! Welcoming entry with 14-foot ceilings framed by Home office with French doors. Formal dining room with a wall of windows just off the family room and kitchen. Large family room with a grand wall of windows and a wood mantel fireplace. Corner island kitchen offers a large walk-in pantry, double wall oven and a 5-burner gas cooktop. Kitchen opens to a dedicated morning area. Game room with French door entry and a wall of windows. Secluded primary suite offers a grand bowed wall of windows. Primary bath features a French door entry, dual vanities, garden tub, separate glass enclosed shower, a linen closet and two walk-in closets. Secondary bedrooms with walk-in closets and a utility room complete this generous design. Extended covered backyard patio. Mud room just off three-car garage.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S221803 - Audubon Park 03, BLOCK 2, Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11609' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419336' WHERE `Matrix_Unique_ID` = '205944949' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:03:37.347' ,`MLSNumber` = '40549888' ,`ListAgentFullName` = 'Carrie Ramsey' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.872279' ,`Longitude` = '-95.442841' ,`PhotoCount` = '26' ,`PostalCode` = '77320' ,`RoomCount` = '8' ,`ListPrice` = '182500.00' ,`Status` = 'Active' ,`StreetName` = 'Lynell' ,`StreetNumber` = '36' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful roughly 2 acres of landscape of Natural Forest right from your back porch! This home features a Kitchen Island with plenty of cabinets and counter space for the chef of the family, open to the family room and overlooks the gorgeous back porch! \r\nPrimary Suite complete with Walk In Shower & separate soaking tub & linen closet, Primary Bedroom has a Texas size closet!!! This property has the perfect amount of land to where you have so much privacy! RV Parking with full hook ups. Love nature? The back porch over looks a large backyard that has a Pool deck already built all you need to do is add the POOL!!!! Lake Trinity with boat ramp access is walking distance away!!! NO HOA' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Riverside (Walker)' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RIVERSIDE HARBOR, BLOCK 11, LOT 3.2, MH LABEL# NTA1664698; /' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '72745' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Riverside Harbor' ,`TaxAmount` = '1626' ,`TaxRate` = '1.7134' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419336' WHERE `Matrix_Unique_ID` = '209589959' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:17:47.397' ,`MLSNumber` = '34765430' ,`ListAgentFullName` = 'Dawn Bajalieh' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.210643' ,`Longitude` = '-94.613568' ,`PhotoCount` = '31' ,`PostalCode` = '77519' ,`RoomCount` = '6' ,`ListPrice` = '358000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 770' ,`StreetNumber` = '26720' ,`StreetSuffix` = 'Road' ,`City` = 'Batson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living at it\'s best! This immaculate 1-story home sits on 5+ acres in the quiet community of Batson. The open floor plan has laminate vinyl flooring throughout. Lots of natural light and neutral colors help make this home feel warm and inviting. The kitchen boasts stainless steel appliances, a walk-in pantry, soft closing custom cabinets- and lots of storage! The utility room is the perfect size for doing your laundry with a 50-gal water heater and a water manifold system that serves as the control center- delivering hot and cold water to the individual fixtures. Primary bedroom with walk-n closet and good-sized secondary bedrooms. The septic is on a maintenance plan and paid up through May 2023. A carport perfect for your RV with 30-amp service for RV hook-up. There is a 10 yr transferable builders warranty. Brand new 2-car garage with power and its own breaker box and a separate storage shed. Everything you need is here and waiting for you. Schedule your showing today.' ,`Acres` = '5.05' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 102 BBB & C RR P# 102-12-E TRACT E I# 2019-99616 11/12/20' ,`LotDesciption` = 'Other' ,`LotSize` = '219978' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '182 - West Hardin County Consolidated' ,`SchoolElementary` = 'WEST HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST HARDIN HIGH SCHOOL' ,`SchoolMiddle` = 'WEST HARDIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'And/Notice/Acceleration Given' ,`TaxAmount` = '2235' ,`TaxRate` = '1.7971' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668419336' WHERE `Matrix_Unique_ID` = '209907520' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:22:05.837' ,`MLSNumber` = '81406603' ,`ListAgentFullName` = 'Anthony Vu' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.863879' ,`Longitude` = '-95.443693' ,`PhotoCount` = '9' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Emma Lou' ,`StreetNumber` = '7010' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION. MOVE IN READY BY DECEMBER 2022. Just north of 610 in Houston\'s growing neighborhood of Acres Homes lies Emma Lou Crossing. Free-standing two-story homes with private fencing and a backyard come together in an open concept floor plan by Hillstone Homes. Upgraded finishes throughout including quartz countertops, eye-catching lighting, wood cabinets and stainless-steel appliances for both style and functionality. Unique tiled master bathroom with a soaker tub and walk-in-shower for a spa feeling time. This 4 homes development awaits your arrival for the new lifestyle you’ve been looking for! Click on the \"Listing Tour\" for your very own viewing! Call today for more information.' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = 'Hillstone' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 1 Block 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2233' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Emma Lou Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419336' WHERE `Matrix_Unique_ID` = '210493532' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:52:36.270' ,`MLSNumber` = '37208878' ,`ListAgentFullName` = 'Erika Navarro' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = 'Katrina Driscoll' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '30.222057' ,`Longitude` = '-95.801867' ,`PhotoCount` = '20' ,`PostalCode` = '77355' ,`RoomCount` = '4' ,`ListPrice` = '340000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lavaca Trail' ,`StreetNumber` = '27025' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two story home with big backyard that overlooks part of the neighborhood. Upstairs is a game room or study area. The kitchen is very spacious that leads to the dining area. Formal living area has high ceilings and leads the primary bedroom. Room measurements are approximate and to be verified by Buyer/buyer agent. One new AC unit was installed in Jan. 2022.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RANCH CREST 04, BLO CK 1, LOT 42' ,`LotDesciption` = 'Other' ,`LotSize` = '16219' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Ranch Crest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419337' WHERE `Matrix_Unique_ID` = '210839341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:38:07.547' ,`MLSNumber` = '42097514' ,`ListAgentFullName` = 'Myra Davis - Nichols' ,`ListOfficeName` = 'Patrick Poteet Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841127' ,`Longitude` = '-95.179377' ,`PhotoCount` = '23' ,`PostalCode` = '77049' ,`RoomCount` = '2' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Villagrove' ,`StreetNumber` = '14003' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is move in ready. It has fresh paint, new flooring, new porch and steps in front. Make your appointment to see this one. You will not be disappointed. Priced just reduced. Act quickly to make this your home.' ,`Acres` = '0.1653' ,`Area` = '2' ,`BuilderName` = 'Champion' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 158 BLK 6 HAMPTON OAKS SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON LAKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hampton Oaks 1' ,`TaxAmount` = '1053' ,`TaxRate` = '2.2893' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419337' WHERE `Matrix_Unique_ID` = '210929545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:11:19.080' ,`MLSNumber` = '61266045' ,`ListAgentFullName` = 'Lourdes Jones' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.001929' ,`Longitude` = '-95.194905' ,`PhotoCount` = '15' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Moonshadows' ,`StreetNumber` = '5302' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1674' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home in a Great location in Atascocita West. Want to be close to everything - this is your place! Lovely 4 bedroom, 2 Bath home with a den area and a dining room. Large backyard with covered patio, comes with storage shed for your yard maintenance tools. Brand New HVAC September 2022. Roof installed 3 years ago! There are no back neighbors directly behind this home. This home is waiting for your personal touches! What are you waiting for? Call your Realtor today to schedule a showing and view this home!' ,`Acres` = '0.2204' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 ATASCOCITA WEST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita West Sec 01' ,`TaxAmount` = '3952' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419337' WHERE `Matrix_Unique_ID` = '211584202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:02:08.587' ,`MLSNumber` = '38211010' ,`ListAgentFullName` = 'Angela Revis' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725518' ,`Longitude` = '-95.368899' ,`PhotoCount` = '8' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Wheeler' ,`StreetNumber` = '2612' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 3 bedroom 2 full bathrooms with detached Garage, fireplace, original hardwood floors in excellent condition, home currently in good livable condition. Roof in great condition approximately 5-8 years old All windows replaced approximately 2-3 years ago' ,`Acres` = '0.1326' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas,Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 22 WASHINGTON TERRACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Washington Terrace' ,`TaxAmount` = '3763' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1939' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419337' WHERE `Matrix_Unique_ID` = '212363244' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:08:00.433' ,`MLSNumber` = '76958867' ,`ListAgentFullName` = 'Maria Cortes' ,`ListOfficeName` = 'Anchor Realty Assoc., Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812633' ,`Longitude` = '-94.991763' ,`PhotoCount` = '18' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '283000.00' ,`Status` = 'Active' ,`StreetName` = 'Osage' ,`StreetNumber` = '4603' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2303' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELL MAINTAINED 4 Bedroom 2.5 bath home located in Meadow Lake. Spacious living & dining area, all bedrooms on second floor. Kitchen offers plenty of cabinets, large counter space, and breakfast nook. Primary Bedroom features high ceilings, bath with shower and separate garden tub. Two vanities and roomy walk-in closet. Two extra rooms on first floor could be used as office/study. Home has tile and Laminate Flooring throughout. Super nice backyard with covered patio. New AC/Heating and duct installed November 2021 + Fresh Exterior Paint.' ,`Acres` = '0.1716' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 4 MEADOW LAKE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Lake Sec 03' ,`TaxAmount` = '4796' ,`TaxRate` = '2.755' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419337' WHERE `Matrix_Unique_ID` = '212625268' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:29:01.423' ,`MLSNumber` = '20890769' ,`ListAgentFullName` = 'Justin Fester' ,`ListOfficeName` = 'THE BROKER Real Estate Firm' ,`SellingAgentFullName` = 'Kaki Herring' ,`SellingOfficeName` = 'Top Guns Realty on Lake Conroe' ,`Latitude` = '30.820629' ,`Longitude` = '-95.458166' ,`PhotoCount` = '25' ,`PostalCode` = '77320' ,`RoomCount` = '7' ,`ListPrice` = '165000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wood Farm Rd Estates' ,`StreetNumber` = '45' ,`StreetSuffix` = 'Road' ,`City` = 'Huntsville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'ve been wanting a cozy cottage in the quiet country, your search is over!! This charming 2 bedroom, 1 bathroom (with bonus room) is located on 1 Acre away from the hustle and bustle of the big city. A partially wooded back yard and mature trees in the front yard help make this location PERFECT!! Need a workshop? This property has that too!! Just far enough away from modern noises, but close enough for modern conveniences. This property has great potential and is priced to SELL!! Don\'t miss out on this amazing opportunity. Call for a showing, TODAY!!' ,`Acres` = '1' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WOOD FARM ROAD ESTATES, LOT 29, ACRES 1.0' ,`LotDesciption` = 'Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wood Farm Road Estates' ,`TaxAmount` = '2455' ,`TaxRate` = '1.7134' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419338' WHERE `Matrix_Unique_ID` = '212738180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:54:41.737' ,`MLSNumber` = '55424913' ,`ListAgentFullName` = 'Christina DeLaTorre' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.958574' ,`Longitude` = '-95.592535' ,`PhotoCount` = '27' ,`PostalCode` = '77429' ,`RoomCount` = '4' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Bent Way' ,`StreetNumber` = '11402' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE! Great floorplan with recent updating throughout. Spacious Corner Lot on a Cul-De-Sac Street. Family friendly community. Zoned to A rated Hamilton Middle School. Roof replaced in 2018. Recently painted a nice neutral color throughout. Inviting living and formal dining area. Spacious kitchen with gas range, dishwasher, microwave and granite counter tops. Large kitchen window looks out into your backyard so you can keep an eye out on the little ones or pets while they enjoy all the green open space. There is a spacious den with fireplace as well that could also be used as a gameroom. The space is so versatile. Recently installed vinyl plank flooring is easy to maintain. Extra storage space in garage. Community Park and Pool. You won\'t want to miss this one. Set up your appt today.' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 50 Block 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '520' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Ridge North' ,`TaxAmount` = '4391' ,`TaxRate` = '2.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419338' WHERE `Matrix_Unique_ID` = '212838524' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:42:56.903' ,`MLSNumber` = '67416773' ,`ListAgentFullName` = 'Suk-Jun Cheng' ,`ListOfficeName` = 'Suk-Jun Cheng' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781888' ,`Longitude` = '-95.476055' ,`PhotoCount` = '15' ,`PostalCode` = '77024' ,`RoomCount` = '3' ,`ListPrice` = '786000.00' ,`Status` = 'Active' ,`StreetName` = 'Highgrove Park' ,`StreetNumber` = '735' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3196' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful brick home zoned to some of the best schools, such as Hunter Creek Elementary, Spring Branch Middle and Memorial High; Fantastic location with direct access to I-10 and 610; centrally located near Galleria, City Center and Medical Center; Nicely appointed in an upscale gated community; Freshly painted interior walls and crown mouldings. New high efficiency A/C and furnace in 2022; new frameless shower enclosure is underway; sprinkler system. Main features include hardwood floors, double-paned windows with plantation shutters, granite countertops, abundant closet space and nice finishes throughout. A large open third floor can be used as a playroom or media room; move-in ready in a great location.' ,`Acres` = '0.0553' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Close In' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 3 HIGHGROVE PARK AMENDED' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '2409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highgrove Park Amd' ,`TaxAmount` = '13330' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419338' WHERE `Matrix_Unique_ID` = '213080800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:32:58.490' ,`MLSNumber` = '13213860' ,`ListAgentFullName` = 'Julie Husband' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Janet Martinez' ,`SellingOfficeName` = 'JPAR - The Sears Group' ,`Latitude` = '29.646649' ,`Longitude` = '-95.139232' ,`PhotoCount` = '26' ,`PostalCode` = '77505' ,`RoomCount` = '7' ,`ListPrice` = '295000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Winterborne' ,`StreetNumber` = '4222' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly updated with lots of upgrades, this oversized home features a massive living area, updated kitchen, breakfast area and an additional den/family room!! You\'ll love the patio covered backyard with new fans, lots of privacy and a workshop!! New roof, new windows, new paint, new flooring, new kitchen countertops and tons more!! Don\'t miss this one!!' ,`Acres` = '0.1742' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 VILLAGE GROVE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'FAIRMONT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Village Grove Sec 01' ,`TaxAmount` = '6119' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419338' WHERE `Matrix_Unique_ID` = '213238080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:12:21.087' ,`MLSNumber` = '42270268' ,`ListAgentFullName` = 'Eliosa Sanchez' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730939' ,`Longitude` = '-94.961544' ,`PhotoCount` = '23' ,`PostalCode` = '77520' ,`RoomCount` = '4' ,`ListPrice` = '163000.00' ,`Status` = 'Active' ,`StreetName` = 'Defee' ,`StreetNumber` = '516' ,`StreetSuffix` = 'Avenue' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home, large living area, spacious kitchen, has an extra room next to kitchen for either office or storage. Huge primary room with nicely updated bathroom, large covered patio, big back yard with good size of concrete deck, with mature trees, great place for family and friends entertainment. Per seller A/C unit recently replaced this year 2022, water heater replaced in 2021, plumbing upgraded in 2021 and roof is 5 years old. This house is in great location, near restaurants and shopping.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 8 LONG A C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'ASHBEL SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Long A C' ,`TaxAmount` = '3560' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419338' WHERE `Matrix_Unique_ID` = '213265177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:07:01.013' ,`MLSNumber` = '66811082' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Ravenna Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395940' ,`Longitude` = '-95.500760' ,`PhotoCount` = '46' ,`PostalCode` = '77318' ,`RoomCount` = '13' ,`ListPrice` = '629900.00' ,`Status` = 'Active' ,`StreetName` = 'Stone Pillar' ,`StreetNumber` = '310' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This move-in ready 1-story open concept floor plan features an extended entry with 13’ ceilings. An expansive kitchen is the heart of this home, featuring abundant cabinet space, working island, and a high bar with seating. The large family room has a full wall of windows and a corner fireplace. The master bedroom boasts 13’ ceilings and a luxurious master bathroom which includes His and Hers sinks, centrally located tub, and a large walk-in closet. Please contact us for more information.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Ravenna Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41 Block 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419339' WHERE `Matrix_Unique_ID` = '213343193' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:43:30.363' ,`MLSNumber` = '92893387' ,`ListAgentFullName` = 'Jarrett Glass' ,`ListOfficeName` = 'Jarrett Glass' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849014' ,`Longitude` = '-95.340663' ,`PhotoCount` = '7' ,`PostalCode` = '77093' ,`RoomCount` = '5' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'La Estancia' ,`StreetNumber` = '2936' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bright, open concept home with living on first floor. Convenient large bedroom and full bath on first floor. 5 cozy bedrooms with great walk in closets with built in shelving and another full bath on second floor. Small one street gated community, convenient to US59 and Hardy Toll Road and neighborhood retail.\r\nTenant Occupied unitl December 31, 2022 at a lease rate of $1,395.00. $5,000 reduction in price or seller concession if closed by Nov 23, 2022.' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 2 LA ESTANCIA R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARCIA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'PATRICK HENRY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'La Estancta Rep 01' ,`TaxAmount` = '2960' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419339' WHERE `Matrix_Unique_ID` = '213352471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:21:20.457' ,`MLSNumber` = '40164868' ,`ListAgentFullName` = 'Gwendolyn Burwell' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Lawrence Jenkins' ,`SellingOfficeName` = 'Infinity Real Estate Group' ,`Latitude` = '29.577441' ,`Longitude` = '-95.379911' ,`PhotoCount` = '40' ,`PostalCode` = '77584' ,`RoomCount` = '6' ,`ListPrice` = '259900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Breezy Pines' ,`StreetNumber` = '2707' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1445' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER! ENJOY YOUR NEW LIFESTYLE IN DESIRABLE ACTIVE 55+ SENIOR COUNTRYPLACE COMMUNITY! See stunning views from Living, Breakfast/Kitchen, & Primary Bedroom. This cul-de-sac lot on golf course is one of the best locations in Countryplace. This light & bright home has fresh paint, High Ceilings, Kitchen Breakfast Area, Dining Room w Bay Window. Large Primary Bedroom has Walk-in Closet, Primary Bath w Garden Tub, Separate Shower, Double Sinks. Enjoy peaceful hours on your back deck in the shade of a grove of mature trees. This active 55+ community has Olympic size Pool, Hot Tub, lighted Tennis Courts, Golf Course, & multitude of Activities at the Clubhouse: Travel Club, Friday Happy Hours at the Grill, Exercise rooms, Library, Game room, Auditorium, & more. Note the 24/7 Manned Security. Ideally located near Hwy 288 & Beltway 8, there\'s easy access to Pearland shopping, restaurants, medical facilities, & only a short drive to downtown Houston, sports arenas, & theater district.' ,`Acres` = '0.1522' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Approved Seniors Project,Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRYPLACE SEC 1 (A0510 F B DRAKE) BLK 5 LOT 26' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course' ,`LotSize` = '6630' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Countryplace Sec 1' ,`TaxAmount` = '4939' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419339' WHERE `Matrix_Unique_ID` = '213427220' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:31:22.660' ,`MLSNumber` = '76819080' ,`ListAgentFullName` = 'Sylvia Reyes' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.986039' ,`Longitude` = '-95.195222' ,`PhotoCount` = '17' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '242900.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Crossing' ,`StreetNumber` = '12202' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully updated home has been fitted with all stainless steel appliances, along with hardwood floors, carpet, and a fresh paint job throughout! The custom touches will make you wish you had thought of It first as you tour this home. The warmth of a real fire is incomparable and with this home you can have that experience in your living room as you sit by your gas fireplace during the holidays!' ,`Acres` = '0.1085' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 CLAYTONS CORNER SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Claytons Corner Sec 3' ,`TaxAmount` = '4952' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419339' WHERE `Matrix_Unique_ID` = '213466960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:43:48.583' ,`MLSNumber` = '47081568' ,`ListAgentFullName` = 'Ryan Hermes' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.830508' ,`Longitude` = '-95.211458' ,`PhotoCount` = '25' ,`PostalCode` = '77320' ,`RoomCount` = '9' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'La Jolla Ct' ,`StreetNumber` = '22373' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2629' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Premium WATERFRONT property with stunning 180 degree views of Lake Livingston in golf course resort community. Model home condition & lovingly maintained with 3 bedrooms, 2 full and 2 half baths. Brand New floors downstairs and in the bathrooms. New paint both inside and outside. Quiet Cul-De-Sac street on an elevated peninsula. Roof is only 3 years old! Boat Dock with one Boat Stall. Home features 2 chimneys, one in the living room and one in the Primary Room. Both chimneys feature stone from floor to ceiling. The Primary Room has its only private Balcony while the guest rooms share a balcony so you can wake up and look over the lake in the morning! The Neighborhood has 24 hour patrolled security. Enjoy the sounds and sights of nature with the native wild life from deer to rabbits.\r\n\r\nPlease look at survey to see the lot being sold. The map shows both lots 2 and 3 as one. The sellers will give the option to any buyers to buy the empty lot (Lot 2). Seller will split if turned down.' ,`Acres` = '' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WATERWOOD - COUNTRY CLUB EST #3, BLOCK 4, LOT 3 Unit 3' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterwood County Club Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668419340' WHERE `Matrix_Unique_ID` = '213520269' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:28:13.377' ,`MLSNumber` = '56581309' ,`ListAgentFullName` = 'Glen Hotchkiss' ,`ListOfficeName` = 'Sticks & Bricks Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.274777' ,`Longitude` = '-94.825364' ,`PhotoCount` = '38' ,`PostalCode` = '77551' ,`RoomCount` = '4' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Palm' ,`StreetNumber` = '2709' ,`StreetSuffix` = 'Circle' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Offering $5000 towards rate buy down or closing costs with full priced offer!! Beautiful Midtown Remodeled 4 bedroom brick home blocks from the seawall. New HVAC, Impact Windows, water heater, fresh paint inside and out (plus two hand painted murals by local artist to enjoy). both bathrooms remodeled (master bath has custom oversize shower and quartz double vanity) and very large walk-in closet too. Very private back patio area with adjoining 11 x 25 shed/workshop. Sub-panel already installed for addition of stand-by generator.\r\n \r\n2021:Roof, HVAC unit in the garage/gameroom, additional 3 feet of blown in insulation over the whole home and above the garage (the 597 sq ft of the garage/gameroom is included in the total sq ft). barbeque grill added in 2022' ,`Acres` = '0.1446' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 LOT 23 PALM CIRCLE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Palm Circle' ,`TaxAmount` = '6554' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419340' WHERE `Matrix_Unique_ID` = '213545627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:31:38.447' ,`MLSNumber` = '67162329' ,`ListAgentFullName` = 'Phaik Chandler' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.155616' ,`Longitude` = '-95.658658' ,`PhotoCount` = '50' ,`PostalCode` = '77362' ,`RoomCount` = '6' ,`ListPrice` = '498000.00' ,`Status` = 'Active' ,`StreetName` = 'Cripple Creek' ,`StreetNumber` = '33903' ,`StreetSuffix` = 'Drive' ,`City` = 'Pinehurst' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1919' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live in tranquility and privacy on this wooded property and yet be only one minute to SH249 which takes you to Tomball and Magnolia quickly. You\'re not far from the Woodlands too! Your new home has been updated with Pella windows (energy efficient), new AC (only 2 years old), new roof (1 year old), new luxury vinyl plank downstairs, water softener/sediment filter, and new dishwasher. Drive up the circular driveway to your estate. Enter the great room - dining and living room combined through grand double doors. To your left, there is one secondary bedroom which leads to a deck, a bathroom and the kitchen. The sun room sits between the kitchen and the dining room. There is a building out the back with water and electricity which could be tailored for other uses with reconfiguration - a home office or a guesthouse. There is a barn too. This is a minimal restriction HOA neighborhood with NO MUD taxes. Horses and livestock are allowed! Come view this amazing property soon!' ,`Acres` = '3.54' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S356003 - CRIPPLE CREEK FARMS 03, LOT 23-A, ACRES 3.54, 50.0' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '154202' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'cripple creek farms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419340' WHERE `Matrix_Unique_ID` = '213659382' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:25:51.547' ,`MLSNumber` = '85732203' ,`ListAgentFullName` = 'Patricia David' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679245' ,`Longitude` = '-95.726334' ,`PhotoCount` = '31' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Juniper Berry' ,`StreetNumber` = '19802' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great new price! Welcome home to Juniper Berry Dr located in Richmond\'s Waterview Estates neighborhood. This spacious three bedroom home resides on a corner lot with a great open floor plan featuring a private home office/study. Relax under the covered patio in backyard with no back neighbors. ! Cameras, alarm system, Ring doorbell, and refrigerator are included. The interior has been recently painted. Zoned to FBISD schools, This wonderful community\'s amenities include walking trails, subdivision pool with slide and water features, splashpad, parks, and tennis courts. Located near the Grand Parkway West, the Westpark Tollway, and HWY 90, the surrounding area is growing and expanding with new retail shopping, restaurants, and entertainment such as Waterview Town Center and The Grand at Aliana. Motivated Seller! Ready for move-in! Open House Saturday 11/19 from 2PM-4PM.' ,`Acres` = '0.1334' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERVIEW ESTATES SEC 2, BLOCK 2, LOT 19' ,`LotDesciption` = 'Corner' ,`LotSize` = '5809' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '615' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'NEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterview Estates Sec 2' ,`TaxAmount` = '5236' ,`TaxRate` = '2.8929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419340' WHERE `Matrix_Unique_ID` = '213765517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:01:25.047' ,`MLSNumber` = '90645051' ,`ListAgentFullName` = 'Jana Owen Perkins' ,`ListOfficeName` = 'Jana Perkins Properties' ,`SellingAgentFullName` = 'Trang Dang' ,`SellingOfficeName` = 'Lone Star Realty' ,`Latitude` = '30.041391' ,`Longitude` = '-95.640654' ,`PhotoCount` = '47' ,`PostalCode` = '77429' ,`RoomCount` = '4' ,`ListPrice` = '439900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Violet Willow' ,`StreetNumber` = '14902' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2683' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED!Beazer ONE OWNER 4/2.5/2 Armstrong plan! BETTER THAN NEW w/ the additions made! Plus the brand new LG WASHER/DRYER LAUNDRY CENTER/ ALL T.V.\'s/ and REFRIGERATOR STAY WITH THE HOME! Wood like ceramic tile, WROUGHT IRON SPINDLES on the staircase, PEX PLUMBING w/ easily accessible access, gas log FIREPLACE, granite island kitchen, SUBWAY TILE backsplash are some of the many BENEFITS!And let\'s not forget the energy efficient windows and thermostats plus the Bayer SPRAY FOAM INSULATION that keep this home ENERGY EFFICIENT 365 days a year!ALL situated on a CORNER LOT adding the your PRIVACY & QUICK ACCESS to the many AMENITIES which include a resort-style swimming pool,DOG PARK, five lakes with walking paths & resident-only fishing, & numerous green spaces.Students in the neighborhood can attend highly rated TOMBALL ISD.Hayden Lakes affords quick access to major thoroughfares (SH 99 and FM 249),shopping, medical & retail.See for yourself all this home & neighborhood has to offer!' ,`Acres` = '0.1759' ,`Area` = '35' ,`BuilderName` = 'Beazer' ,`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` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 2 HAYDEN LAKES SEC 7' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7663' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hayden Lakes' ,`TaxAmount` = '9062' ,`TaxRate` = '2.8172' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419340' WHERE `Matrix_Unique_ID` = '213776446' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:16:17.433' ,`MLSNumber` = '78741490' ,`ListAgentFullName` = 'Charles Jansky' ,`ListOfficeName` = 'Vip Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.276894' ,`Longitude` = '-97.128720' ,`PhotoCount` = '6' ,`PostalCode` = '77995' ,`RoomCount` = '7' ,`ListPrice` = '665000.00' ,`Status` = 'Active' ,`StreetName` = 'Juniper' ,`StreetNumber` = '536' ,`StreetSuffix` = 'Trail' ,`City` = 'Yoakum' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SELLER IS OFFERING A $6,000 RATE BUYDOWN - Don\'t miss the opportunity to take advantage of this incentive! Post-card perfect views and uncompromising qualities make this gorgeous custom home one you don\'t want to miss! This meticulously maintained, trophy property is located in the coveted community of Juniper Ridge subdivision, on just over two acres of land. As you walk through the double front doors, you\'ll walk into the gorgeous living room with soaring ceilings that is flooded with natural light. The flowing layout, chef\'s kitchen, and huge game room, make this home great for entertaining family and friends. After a long day at work, you\'ll be able to restore and relax on your patio and look into the luscious backyard. This property also features a guesthouse / MIL suite, equipped with a full kitchen, living room, utility room, bedroom, bathroom, and walk-in closet, and has its own private driveway. Don\'t miss this exquisite living opportunity, schedule your private showing today!' ,`Acres` = '1.01' ,`Area` = '68' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'JUNIPER RIDGE SD, LOT 17, ACRES 1.0100, LOT 16 ACRES 1.09' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '177 - Yoakum' ,`SchoolElementary` = '' ,`SchoolHigh` = 'YOAKUM HIGH SCHOOL' ,`SchoolMiddle` = 'YOAKUM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Juniper Ridge SD' ,`TaxAmount` = '' ,`TaxRate` = '1.8692' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419341' WHERE `Matrix_Unique_ID` = '213814553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:41:49.247' ,`MLSNumber` = '7369390' ,`ListAgentFullName` = 'Tricia Hudson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.616751' ,`Longitude` = '-95.193649' ,`PhotoCount` = '11' ,`PostalCode` = '77034' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Babbitt' ,`StreetNumber` = '13430' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2295' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 13430 Babbitt Ct located in the Southway neighborhood! Easy access to I-45 & Beltway 8! This 4 Bed, 2.5 bath home has had recent upgrades including, new composite 30 year roof as of 2020, new wood tile flooring as of 2020, Dolomite kitchen countertops as of 2021, water heater replaced in 2018 and REME HALO Air Duct purifier with HVAC. Tall ceilings as you walk through the front door gives this home a very open feel! The primary suite features an en-suite bathroom with soaker tub and separate shower. As you journey upstairs you will see a loft perfect for a kids play area or gamer area. The best feature about the backyard is NO BACK NEIGHBORS! Home also sits right off the cul-de-sac and is great play area for kids and/or additional parking. THIS HOME IS MOVE-IN READY. Come see it before it\'s gone!' ,`Acres` = '0.0577' ,`Area` = '3' ,`BuilderName` = 'Tremont Homes, Inc' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 4 SOUTHWAY SEC 7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '2514' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'GENOA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southway' ,`TaxAmount` = '6328' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419341' WHERE `Matrix_Unique_ID` = '213869196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:37:00.343' ,`MLSNumber` = '96666914' ,`ListAgentFullName` = 'Sandra Acord' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722607' ,`Longitude` = '-96.078653' ,`PhotoCount` = '6' ,`PostalCode` = '77474' ,`RoomCount` = '12' ,`ListPrice` = '1199000.00' ,`Status` = 'Active' ,`StreetName` = 'Verm' ,`StreetNumber` = '5655' ,`StreetSuffix` = 'Road' ,`City` = 'Sealy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3819' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE 10/30/22 1:00-5:00. TV segment filmed at property 2019: https://youtu.be/iULLGZPaGdk. 5.49 acres of the prettiest slice of Texas around & it just feels like Bluebonnets & BBQ here. But yall, don\'t take my word for it, come see yourself. It\'s just a feeling impossible to capture in a 2D image, in my very humble opinion, of course. So, if you\'ve ever known \"real\" country lifestyle, then yea, ya know... it\'s just freaking fun as heck! No other words needed, yall know. If your fun is cutting loose around bonfires w/neighbors & friends, no city lights, starry skies, country music, winding dirt roads, sights & sounds of nature no traffic, trails, small-town charm, Friday-night HS football, then yea, ya just may have found the best spot. If you\'re getting ready for the impending zombie apocalypse, survival odds increase dramatically when there\'s self-sustainable opportunities.' ,`Acres` = '5.49' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'OXFORD ESTATES SUBDBLOCK 1 LOT 2' ,`LotDesciption` = 'Ravine,Wooded' ,`LotSize` = '239144' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Oxford Estates Sub' ,`TaxAmount` = '10441' ,`TaxRate` = '1.8132' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419341' WHERE `Matrix_Unique_ID` = '213897494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:24:48.197' ,`MLSNumber` = '49661225' ,`ListAgentFullName` = 'Paula Blank' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = 'Paula Blank' ,`SellingOfficeName` = 'Southern Star Realty' ,`Latitude` = '30.016433' ,`Longitude` = '-95.502421' ,`PhotoCount` = '48' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '399950.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sampras Ace' ,`StreetNumber` = '6327' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you a nature person? You are only a short walk to Collins Park, and nature preserve via trails. You will love the natural light provided by this beautiful homes lg windows and open floorplan, 21 ft ceilings from front to back with its primary bedroom located downstairs as well as having 4 other bedrooms plus the game room. RainSoft water filtration system for the entire house, including a Reverse Osmosis filtration system in the kitchen installed in the last year. The kitchen has been updated with shaker style cabinets with butcher block countertops and a custom live edge bar. You will have 2 a/c units which are both under 2 yrs. This home contains new 2\" blinds, natural Brazilian stone tile which is in the secondary bath. A wide staircase which leads upstairs to balcony/catwalk and has an open view to downstairs. The large backyard has a 8 ft pool with jacuzzi, even a great shaded area with seating/firepit area. Home is just a short 10 min drive to Interstate 45 or Hwy 249.' ,`Acres` = '0.1887' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 WIMBLEDON CHAMPIONS GARDEN EST' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wimbledon Champions Garden Estate' ,`TaxAmount` = '7857' ,`TaxRate` = '2.6165' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1668419341' WHERE `Matrix_Unique_ID` = '213925194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:07:01.013' ,`MLSNumber` = '17308466' ,`ListAgentFullName` = 'Lauren Friese' ,`ListOfficeName` = 'Tilbury Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824355' ,`Longitude` = '-95.471470' ,`PhotoCount` = '44' ,`PostalCode` = '77092' ,`RoomCount` = '8' ,`ListPrice` = '389999.00' ,`Status` = 'Active' ,`StreetName` = 'Lamonte' ,`StreetNumber` = '5406' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcoming Front Porch perfect for “Spilling the tea” with others. The peaceful \r\n view the Landscaped Lawn.The light & bright Modern Ranch freshly painted light repose gray interior, with 2\" white blinds compliments the white base boards framing gray washed laminate floors throughout the design scheme. The bedrooms with fresh carpet & ceiling fans lights & great closets The spa inspired bathrooms: granite counter tops, shaker cabinetry, subway tile backsplash and porcelain tile. The kitchen\'s chic custom built in white cabinetry, with satin nickel pulls; salt & pepper granite counter & subway tile backsplash. The energy efficient Frigidaire stainless steel dishwasher, microwave and \"wonder stove\" with gas range and convection oven/ Air Fryer. Other energy efficient features recessed lighting, digital thermostats, insulated doors and Low E windows. Don\'t forget the exterior details fresh paint and hardi & Covered Porches and deck and storage shed. Home warranty included!!' ,`Acres` = '0.1515' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 11 MANGUM MANOR SEC 2 R/P' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mangum Manor Sec 02 R/P' ,`TaxAmount` = '5649' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419342' WHERE `Matrix_Unique_ID` = '214043853' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:12:22.100' ,`MLSNumber` = '60600986' ,`ListAgentFullName` = 'Wei Zhang' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.883149' ,`Longitude` = '-95.359302' ,`PhotoCount` = '15' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '52000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodlands' ,`StreetNumber` = '238' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for your Dream House in Golf Course neighborhood also with community pool? walk to fishing, camping and hunting by the lake? Here you found the gem in the woods! single home built in 1993 and with your handy-man skill and imagination to turn this house to your Dream Home! house is 2 bedrooms and 1 bath over 1000 sft2 with about 400 sft2 garage, it sits on quarter acre wooded lot with fenced backyard! House is not livable and need a lot of work, house to be sold at AS IS condition, Owner will take note, monthly payment is $500 (PI) at 20 years term, $2000 to get in' ,`Acres` = '0.25' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Riverside (Walker)' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'TRINITY PLANTATION, BLOCK 10 LOT 16' ,`LotDesciption` = 'Other' ,`LotSize` = '13395' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trinity Plantation' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1668419342' WHERE `Matrix_Unique_ID` = '214175194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:59:21.627' ,`MLSNumber` = '73399451' ,`ListAgentFullName` = 'Sandra Irizarry' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = 'Lisseth Larios' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '29.828609' ,`Longitude` = '-95.703989' ,`PhotoCount` = '31' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '309900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Harris Mill' ,`StreetNumber` = '3835' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this Beautiful 1 story 4 bdrm or 3 + study/office 2 bath home. High ceilings, upgraded new kitchen with lots of cabinet and counter space, nice and spacious breakfast bar overlooking the family den and dining area. \r\nReverse osmosis/water softener + refrigerator will stay. Recently install roof/ AC. Interior home has custom tiles throughout no carpet. Spacious backyard with a beautiful sparkling pool + storage shed and still plenty of grass space to enjoy and entertain with no backdoor neighbors. This home is located on a culdesac close to schools perfect for your family!' ,`Acres` = '0.2169' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 WESTFIELD SEC 20' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RHOADS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Sec 20' ,`TaxAmount` = '6093' ,`TaxRate` = '2.822' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419342' WHERE `Matrix_Unique_ID` = '214187574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:04:33.257' ,`MLSNumber` = '50840861' ,`ListAgentFullName` = 'Terri Chase' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Maggie Diaz' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.852571' ,`Longitude` = '-94.811179' ,`PhotoCount` = '21' ,`PostalCode` = '77523' ,`RoomCount` = '7' ,`ListPrice` = '369800.00' ,`Status` = 'Option Pending' ,`StreetName` = 'River Oaks' ,`StreetNumber` = '214' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPDATED THROUGHOUT, Highly sought after, well-established River Oaks Sub., small community surrounded by mature trees, quiet, sitting on 1/2 acre! Well-maintained, with NEW garage doors, flooring including lifetime luxury vinyl, new carpet, paint, soft-closing cabinets. New high-efficiency HVAC system, new electrical receptacles, new lighting, new appliances. 10-year roof that\'s in great shape. NO HOA! So many upgrades!! Slab is in the backyard and ready to store your RV, camper, or build yourself a shed, at 30\' x 40\'. Tax rate is only 1.7% to date. BARBERS HILL ISD!!' ,`Acres` = '0.5' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '2 3 RIVER OAKS' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = '3 River Oaks' ,`TaxAmount` = '4267' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419342' WHERE `Matrix_Unique_ID` = '214223886' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:30:09.233' ,`MLSNumber` = '62073749' ,`ListAgentFullName` = 'Robert Goleman' ,`ListOfficeName` = 'NextHome Realty Center' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029105' ,`Longitude` = '-95.631630' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '14' ,`ListPrice` = '490000.00' ,`Status` = 'Active' ,`StreetName` = 'Chatfield Manor' ,`StreetNumber` = '13134' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 BR-3 1/2 BATH- Open Concept w/ vaulted high ceiling, natural light overlooking the pool; Kitchen is a Chef\'s dream w/ counters & cabinet space galore; granite countertops, 5 burner gas cooktop; stainless steel appliances, under cabinet lighting, and Butler\'s Pantry. Ideal entertainment space for holiday guests. Primary Bedroom has view of pool, crown molding, solar blackout roll down shades, french doors leading into bath w/2 sinks and vanity area, & to large walk in closet. Game Room w/ theatre grade curtains and sound ballasts. 2 bedrooms upstairs have walk-in closets & high ceilings. Attic floored for add\'l storage & radiant barrier for lower energy bills. Garage is wired for sound, Custom workbench, storage cabinet & overhead storage rack system. Backyard plumbed for gas, with covered patio w/ curtains & mood lighting, a pool with falls; 6 person hot tub; mood lighting, and wired for sound outside and inside the home. New ROOF installed summer 2022. Previous Yard of the month!!' ,`Acres` = '0.1729' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 VILLAGES OF NORTHPOINTE WEST SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7532' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1035' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Villages/Northpoint West Sec 03' ,`TaxAmount` = '9654' ,`TaxRate` = '3.0564' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419343' WHERE `Matrix_Unique_ID` = '214230435' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:25:10.347' ,`MLSNumber` = '26451695' ,`ListAgentFullName` = 'Jennifer Dodds' ,`ListOfficeName` = 'RE/MAX Preferred Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.907801' ,`Longitude` = '-95.646424' ,`PhotoCount` = '40' ,`PostalCode` = '77095' ,`RoomCount` = '3' ,`ListPrice` = '294000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Mountain' ,`StreetNumber` = '15846' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1745' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is your chance to own a piece of paradise in Copperfield! This wonderful two-story, traditional home is situated on an INCREDIBLE 18,900 SQFT LOT and offers PLENTY of space for outdoor activities and entertainment. Upon entering the home, you will be greeted by fresh paint colors, modern fixtures and beautiful hardwood and tile flooring. The first floor features an office/study space, 1/2 bath, living room with soaring ceilings and a cozy fireplace. The kitchen has been updated with new cabinets, granite countertops, marble backsplash and stainless steel appliances. A beautiful wrought-iron staircase leads up to the second floor where you will find two bedrooms, a full bathroom and the primary bedroom suite. The primary bedroom suite offers an updated Texas size shower with cabinetry and granite countertops. Exterior painted 2021, roof 2015, furnace 2015,compressor 2019.' ,`Acres` = '0.4339' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 38 COPPERFIELD NORTHMEAD VLG 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '565' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Copperfield Northmead Village' ,`TaxAmount` = '4246' ,`TaxRate` = '2.3216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419343' WHERE `Matrix_Unique_ID` = '214273723' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:02:40.393' ,`MLSNumber` = '13073141' ,`ListAgentFullName` = 'Lea Jamandre' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773357' ,`Longitude` = '-95.758734' ,`PhotoCount` = '43' ,`PostalCode` = '77450' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'North Fork' ,`StreetNumber` = '22306' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Cimarron! A quaint Katy neighborhood nestled right off of Mason and only 1.8 miles from I-10. Convenience is king here. Mason is filled with restaurants, shops, grocery stores, and services. You won\'t have to go far to get what you need. This neighborhood is zoned to top tier Katy ISD schools including Cinco Ranch High! This home has no backyard neighbors and backs up to a hike and bike greenbelt. A simple gate modification and you\'ll be able to access miles of trails along the bayou, perfect for dog owners. The house has been installed with new electrical, plumbing, HVAC unit, water heater, carpet, and has been freshly painted. The roof is recent (2017), and the backyard has plenty of open space along with a large covered patio. The kitchen opens up to the vaulted ceiling family room with a long breakfast bar, perfect for entertaining. Most of the countertops have been replaced with granite, and the house comes with a security camera system...what more can you ask for?' ,`Acres` = '0.2032' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 CIMARRON SEC 1 R/P' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '462' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Sec 01 R/P' ,`TaxAmount` = '4356' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419343' WHERE `Matrix_Unique_ID` = '214274247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:11:42.913' ,`MLSNumber` = '49014604' ,`ListAgentFullName` = 'James Pressler' ,`ListOfficeName` = 'Pressler Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545217' ,`Longitude` = '-95.666535' ,`PhotoCount` = '31' ,`PostalCode` = '77479' ,`RoomCount` = '7' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Shady Bend' ,`StreetNumber` = '1411' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3017' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Plantation home in Greatwood\'s sought after Brooks Mill neighborhood within walking distance to Campbell Elementary. Stunning balcony view of main living area. The spacious living area flows from the entry to kitchen and out to sparkling pool. Front room as you enter could function as formal living, formal dining, etc. Large open kitchen splits into breakfast room. Custom blinds. Stainless steel kitchen appliances. Get ready for entertaining family and friends in the spacious backyard with a pool and hot tub.' ,`Acres` = '0.1842' ,`Area` = '30' ,`BuilderName` = 'Plantation' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD BROOKS MILL SEC 1, BLOCK 5, LOT 3' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '8023' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Brooks Mill' ,`TaxAmount` = '7623' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419343' WHERE `Matrix_Unique_ID` = '214336303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:58:33.577' ,`MLSNumber` = '8564271' ,`ListAgentFullName` = 'Darryl Hill' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045198' ,`Longitude` = '-95.645918' ,`PhotoCount` = '29' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '448000.00' ,`Status` = 'Active' ,`StreetName` = 'Huckleberry Harvest' ,`StreetNumber` = '15206' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful spacious home in a premium new neighborhood with low property taxes (rare). Zoned to highly desirable Tomball ISD and A Rated high school. A luxury built Perry classic 1 story with high 12-13 ft ceilings, open concept, 4 bedrooms, 3 full bathrooms, Formal dining and an office\r\nMassive extended patio, water fountain and water sprinkler system.' ,`Acres` = '0.1791' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 HAYDEN LAKES SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hayden Lakes' ,`TaxAmount` = '10718' ,`TaxRate` = '2.8172' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419343' WHERE `Matrix_Unique_ID` = '214342844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:04:15.580' ,`MLSNumber` = '29868634' ,`ListAgentFullName` = 'Hung Dang' ,`ListOfficeName` = 'The Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696495' ,`Longitude` = '-95.623653' ,`PhotoCount` = '29' ,`PostalCode` = '77083' ,`RoomCount` = '3' ,`ListPrice` = '274999.00' ,`Status` = 'Active' ,`StreetName` = 'Puerta Vallarta' ,`StreetNumber` = '7434' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! This beautiful residence is desirability located near by restaurants and entertainment. Freshly painted walls, no carpet in the house, granite countertops. Master bathroom frameless shower door is scheduled to be installed. What is not to love? Wont last schedule your tour now!' ,`Acres` = '0.1217' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 6 PHEASANT RUN VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'LIESTMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'KILLOUGH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pheasant Run Village' ,`TaxAmount` = '3414' ,`TaxRate` = '2.397' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419344' WHERE `Matrix_Unique_ID` = '214344482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:03:39.330' ,`MLSNumber` = '76824492' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000746' ,`Longitude` = '-95.463901' ,`PhotoCount` = '12' ,`PostalCode` = '77014' ,`RoomCount` = '3' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Bammelwood' ,`StreetNumber` = '2506' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1394' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exciting 3 bedroom 2.5 bathroom home! Be greeted by great curb appeal, and a covered front porch. There are neutral colors throughout, and ample kitchen space. Make this your home today!' ,`Acres` = '0.0859' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 BAMMEL VILLAGE SEC 02 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '3740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '366' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MAJOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bammel Village Sec 02 Rep 01' ,`TaxAmount` = '4109' ,`TaxRate` = '2.8192' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419344' WHERE `Matrix_Unique_ID` = '214383943' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:24:22.033' ,`MLSNumber` = '14044880' ,`ListAgentFullName` = 'Adeel Adnan' ,`ListOfficeName` = 'M&M Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.963201' ,`Longitude` = '-95.165033' ,`PhotoCount` = '36' ,`PostalCode` = '77044' ,`RoomCount` = '9' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Breakwater Path' ,`StreetNumber` = '13431' ,`StreetSuffix` = 'Loop' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful one story Perry home located in the sought-after Lakeshore subdivision. This home boasts 4 large bedrooms, 3 baths, 3 car garage, and beautiful patio. It is one of the few homes that sits on an oversized lot, perfect for a family. As you walk into the home, you will notice a long entryway with tall ceilings and floor-to-ceiling windows. A spacious home office/study has double entry doors with beautiful rich wood flooring, handcrafted built-in shelving/desk and a nice view out the front of the home. As you move into the great room, you experience a large gathering space opening into the kitchen and breakfast area. The kitchen features plenty of oversized cabinetry, island with storage, granite countertops and stainless steel appliances. This home also features 3 additional bedrooms, two of which share an en suite full bath. The exterior custom patio and pergola with a huge yard are perfect and spacious enough for entertaining.' ,`Acres` = '0.2565' ,`Area` = '1' ,`BuilderName` = 'PERRY HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 LAKESHORE SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11172' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeshore Sec 10' ,`TaxAmount` = '10674' ,`TaxRate` = '2.863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419344' WHERE `Matrix_Unique_ID` = '214487755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:09:54.077' ,`MLSNumber` = '3105527' ,`ListAgentFullName` = 'Angelina Keck' ,`ListOfficeName` = 'Angelina Keck Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.757650' ,`Longitude` = '-95.496837' ,`PhotoCount` = '29' ,`PostalCode` = '77057' ,`RoomCount` = '7' ,`ListPrice` = '424900.00' ,`Status` = 'Active' ,`StreetName` = 'Riverview' ,`StreetNumber` = '6320' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0826' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 11 (IMPS*0934700000050) WOODWAY GLEN SEC 1 2ND R' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '3600' ,`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` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Woodway Glen Sec 01 02 R/P' ,`TaxAmount` = '6100' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419344' WHERE `Matrix_Unique_ID` = '214496765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:14:03.450' ,`MLSNumber` = '38184367' ,`ListAgentFullName` = 'Tommy Nguyen' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.826733' ,`Longitude` = '-95.742468' ,`PhotoCount` = '29' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '295900.00' ,`Status` = 'Active' ,`StreetName` = 'Bridgemeadows' ,`StreetNumber` = '21219' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely remodeled, 3 bedrooms + 2 bathrooms. dual rainforest shower heads and modernized amenities in the primary bathroom, quartz kitchen countertop. new paint, new vanities, green back yard with covered patio. Walking distant to 2 nearby school. Community pool, quick access to Grand Parkway 99 or Katy 10 for commute.' ,`Acres` = '0.1263' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 2 LAKES OF BRIDGEWATER SEC 7' ,`LotDesciption` = 'Other' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakes Bridgewater Sec 07' ,`TaxAmount` = '4868' ,`TaxRate` = '2.8233' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419345' WHERE `Matrix_Unique_ID` = '214517856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:12:05.720' ,`MLSNumber` = '96648638' ,`ListAgentFullName` = 'Mark Schuetz' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.598241' ,`Longitude` = '-95.137318' ,`PhotoCount` = '49' ,`PostalCode` = '77059' ,`RoomCount` = '13' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Mill Garden' ,`StreetNumber` = '13915' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Village Builders \"Richmond\" plan has 4 bedrooms and 3 full baths, and is situated at the end of quiet a cul-de-sac in desirable NorthFork subdivision. The floor plan is one of it\'s strong suits with 2 bedrooms and 2 full baths on the first floor, making a great alternative for those considering 1 story. It has high ceilings throughout, top and bottom. The seller has recently installed new vinyl plank floors and carpet on the first floor. The upstairs features a Large gameroom that overlooks the entryway. This home has dual-zone HVAC controls. The cabinets have just been painted white, and all commodes are new. Outdoors- the home sits on a lot over 1/3 acre, has plenty of room for parking several cars with the 3-car detached garage. The back yard features both covered and uncovered patio and deck areas. This is a gorgeous home with tremendous value and amazing potential. Priced low for the new owner to provide some TLC. Come see in person to truly appreciate this home!' ,`Acres` = '0.3705' ,`Area` = '7' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 16 NORTHFORK SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '16138' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'NORTH POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northfork' ,`TaxAmount` = '8226' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419345' WHERE `Matrix_Unique_ID` = '214545647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:22:41.637' ,`MLSNumber` = '54945970' ,`ListAgentFullName` = 'Darby Grimmett' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.201377' ,`Longitude` = '-94.945650' ,`PhotoCount` = '43' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Oleander' ,`StreetNumber` = '4020' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful extensively remodeled & fully furnished BEACHSIDE home located in Palm Beach, conveniently located on Galveston’s “West End” between 12 Mile Rd and 13 Mile Rd. Incredible opportunity - perfect as an INCOME PRODUCING investment property (Sleeps 18 or more), family getaway or permanent residence. The main level features an incredible kitchen, complete with island and an abundance of seating, and is open to the family room. Four bedrooms (two master bedrooms) and three full baths + separate sitting areas can also be found as well on the main area - perfect for multiple families staying together. Guest quarters with full bathroom on the ground floor for additional family & friends (is NOT included in bed/bath count of main living area). Large decks, outdoor shower, covered outdoor living areas, and storage area (with everything you need to enjoy the beach)! This property truly has it all - renovated AND a quick walk to the beach, yet close to Galveston\'s popular island venues.' ,`Acres` = '0.1087' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR S 1/2 OF LOT 39 (39-1) BLK 2 PALM' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4736' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Palm Beach' ,`TaxAmount` = '7824' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419345' WHERE `Matrix_Unique_ID` = '214549757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:41:00.407' ,`MLSNumber` = '18551613' ,`ListAgentFullName` = 'Jill Morris' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.744813' ,`Longitude` = '-95.593509' ,`PhotoCount` = '21' ,`PostalCode` = '77077' ,`RoomCount` = '7' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Waldemar' ,`StreetNumber` = '12111' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this beautifully renovated gem on a large over-sized lot with massive oak trees all around. Step inside this 4 bedroom, 2.5 bath home to find well maintained character and charm. Updates include fresh paint throughout, new pipes replacing the galvanized plumbing, recent HVAC system, energy efficient and sound reducing double pane windows, french doors, bay windows, remodeled kitchen with stainless appliances, quartz countertops, and freshly painted cabinets, remodeled bathrooms, engineered wide plank walnut flooring throughout the downstairs, new driveway and walkway, and electric driveway gate. You\'ll appreciate the custom front door, built in surround sound speakers, massive closets, and plenty of storage!' ,`Acres` = '0.2083' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 12 ASHFORD VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '673' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford Village' ,`TaxAmount` = '9489' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419345' WHERE `Matrix_Unique_ID` = '214565242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:08:44.173' ,`MLSNumber` = '76345460' ,`ListAgentFullName` = 'Kelly Simon' ,`ListOfficeName` = 'KSP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159041' ,`Longitude` = '-95.071551' ,`PhotoCount` = '7' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '224990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102 D' ,`StreetNumber` = '108' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Lincoln Model, part of the Liberty series brought to you by NHC. The Lincoln is a 4 bedroom, 2 bathroom, home with a 2 car garage. Open-concept throughout the living, kitchen and dining areas. The kitchen features a breakfast bar, shaker style cabinets, stainless steel GE appliances, gas stove and a Moen faucet. The primary retreat located at the back of the home has double sinks and a nice size walk-in closet. Hardie siding, Sherwin Williams paint, lowE windows and vinyl flooring throughout are just a few of upgrades in this home. Call the sales office for more information.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'National Home Corp' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5106 Blk 50, Santa Fe, Sec 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419346' WHERE `Matrix_Unique_ID` = '214574610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:57:11.290' ,`MLSNumber` = '10045742' ,`ListAgentFullName` = 'Kelly Simon' ,`ListOfficeName` = 'KSP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159780' ,`Longitude` = '-95.071951' ,`PhotoCount` = '6' ,`PostalCode` = '77327' ,`RoomCount` = '9' ,`ListPrice` = '314990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102 D' ,`StreetNumber` = '159' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Jefferson, part of the Liberty series brought to you by NHC. The Jefferson is a large 5 bedroom, 3 bathroom home with a 2 car garage. This home has TWO primary bedrooms! Large downstairs primary retreat has double sinks and a large walk-in closet. The downstairs also features an open floor plan throughout the main living areas and a flex/office space at the front of the home. The kitchen features shaker style cabinets, stainless steel GE appliances, gas range and a Moen faucet. The upstairs primary retreat also features double sinks and a HUGE walk-in closet. Three additional bedrooms upstsairs all with walk-in closets. Hardie siding, Sherwin Williams paint, lowE windows and vinyl flooring throughout are just a few of upgrades in this home. Call the sales office for more information.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'NHC' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5110, BLK 50, SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419346' WHERE `Matrix_Unique_ID` = '214581086' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:37:36.050' ,`MLSNumber` = '82543780' ,`ListAgentFullName` = 'Kelly Simon' ,`ListOfficeName` = 'KSP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159964' ,`Longitude` = '-95.088077' ,`PhotoCount` = '6' ,`PostalCode` = '77327' ,`RoomCount` = '8' ,`ListPrice` = '239990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102 D' ,`StreetNumber` = '79' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Monroe model, which is part of the Liberty series brought to you by NHC. The Monroe is a 4 bedroom, 2 bathroom home with a flex space and 2 car garage. Open concept throughout the living, kitchen and dining room. The kitchen features a breakfast bar, shaker style cabinets, stainless steel GE appliances, gas range and a Moen faucet. The primary retreat located at the back of the home has double sinks, linen closet and a nice sized walk-in closet. Hardie siding, Sherwin Williams paint, lowE windows and vinyl flooring throughout are just a few of upgrades in this home. Call the sales office for more information.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'NHC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5118, BLK 50, SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6970' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419346' WHERE `Matrix_Unique_ID` = '214581422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:16:43.533' ,`MLSNumber` = '53788878' ,`ListAgentFullName` = 'Kelly Simon' ,`ListOfficeName` = 'KSP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159068' ,`Longitude` = '-95.071624' ,`PhotoCount` = '7' ,`PostalCode` = '77327' ,`RoomCount` = '8' ,`ListPrice` = '229990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102 D' ,`StreetNumber` = '118' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Redwood Model, part of the Freedom Series brought to you by NHC. The Redwood is a 4 bedroom, 2.5 bath, home with a 1 car garage. The first floor featurse an open-concept throughout the living, kitchen, dining areas and has a flex space located at the front of the home. The kitchen features a breakfast bar, shaker style cabinets, stainless steel GE appliances, gas range, Moen faucet and a walk-in pantry. The primary retreat located upstairs has a nice size walk-in closet. Three additional secondary bedrooms, full bath and laundry room are also located upstairs. Hardie siding, Sherwin Williams paint, lowE windows and vinyl flooring throughout are just a few of upgrades in this home. Call the sales office for more information.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'NHC' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5107, BLK 50, SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419346' WHERE `Matrix_Unique_ID` = '214581634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:32:07.087' ,`MLSNumber` = '11359978' ,`ListAgentFullName` = 'Kelly Simon' ,`ListOfficeName` = 'KSP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159618' ,`Longitude` = '-95.071396' ,`PhotoCount` = '8' ,`PostalCode` = '77327' ,`RoomCount` = '8' ,`ListPrice` = '239990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102 D' ,`StreetNumber` = '109' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2001' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Shenandoah Model, part of the Freedom Series brought to you by NHC. The Shenandoah is a 4 bedroom, 2.5 bath home with a flex space downstairs, gameroom upstairs and a 2 car garage. Open-concept throughout the living, kitchen and dining areas. The kitchen features a breakfast bar, shaker style cabinets, stainless steel GE appliances, gas stove and a Moen faucet. The large primary retreat located at the upstairs has a nice size walk-in closet. Three additional bedrooms, a gameroom and laundry room are also located upstairs. Hardie siding, Sherwin Williams paint, lowE windows and vinyl flooring throughout are just a few of upgrades in this home. Call the sales office for more information.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'NHC' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5115 BLK 50 SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6970' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419346' WHERE `Matrix_Unique_ID` = '214581734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:50:07.140' ,`MLSNumber` = '83771178' ,`ListAgentFullName` = 'Kelly Simon' ,`ListOfficeName` = 'KSP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159586' ,`Longitude` = '-95.071306' ,`PhotoCount` = '7' ,`PostalCode` = '77327' ,`RoomCount` = '9' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102 D' ,`StreetNumber` = '99' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Jackson, part of the Liberty series brought to you by NHC. The Jackson is a large 5 bedroom, 3 bathroom home, with a gameroom upstairs and a 2 car garage. Downstairs has a nice open floor plan throughout the main living areas including kitchen, dining and living rooms. The kitchen features a breakfast bar, shaker style cabinets, stainless steel GE appliances, gas range, Moen faucet and walk-in pantry. Located downstairs is a large secondary bedroom with walk-in closet that could be an office or downstairs primary. The upstairs primary retreat features double sinks and a HUGE walk-in closet. Upstairs also features 3 other large bedrooms, a secondary bathroom with double sinks, a game room and a large laundry room. Hardie siding, Sherwin Williams paint, lowE windows and vinyl flooring throughout are just a few of upgrades in this home. Call the sales office for more information.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = 'NHC' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5116 BLK 50 SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6970' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668419347' WHERE `Matrix_Unique_ID` = '214581838' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:38:37.670' ,`MLSNumber` = '92806090' ,`ListAgentFullName` = 'Jennifer Wauhob' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Rachel Bain' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.786568' ,`Longitude` = '-95.384672' ,`PhotoCount` = '26' ,`PostalCode` = '77009' ,`RoomCount` = '2' ,`ListPrice` = '595000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bayland' ,`StreetNumber` = '1006' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming bungalow in the heart of The Heights! Zoned to highly sought after Travis Elementary, this home boasts beautiful hardwood floors, arched walkways,brick fireplace and an updated kitchen. You\'ll love the bright and open floor plan! Walkable to so many Heights favorites and just minutes from I 10, downtown, shopping and dining. This gorgeous home won\'t last long, schedule your private showing today!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 14 NORHILL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Norhill' ,`TaxAmount` = '11825' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419347' WHERE `Matrix_Unique_ID` = '214604208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:07:05.133' ,`MLSNumber` = '81905054' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'RE/MAX Legends' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.155842' ,`Longitude` = '-95.475883' ,`PhotoCount` = '37' ,`PostalCode` = '77380' ,`RoomCount` = '7' ,`ListPrice` = '685000.00' ,`Status` = 'Active' ,`StreetName` = 'Wooded Park' ,`StreetNumber` = '62' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2782' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOW MAINTENANCE LIVING AT ITS FINEST! HIGHLY SOUGHT-AFTER EAST SHORE LOCATION! Super Functional Interior Layout w/First Floor Kitchen & Living Area, 2nd Floor Bedrooms, & Huge 3rd Floor Gameroom/4th Bedroom w/Full Bath! Impressive Foyer Opens to Spacious Living Area - Beautiful Coffered Ceiling, Hardwoods, Incredible Wall of Built-Ins, & Gas Log Fireplace - PLUS Wall of Windows! Abundant Natural Light! Gourmet Island Kitchen: Stainless Appliances Including 5-Burner Gas Cooktop, Fridge, Built-In Wine Chiller, Walk-In Pantry, & 42\" Cabinetry w/Under Cabinet Lighting! King-Sized Master Suite - Luxurious Bath with Jetted Tub, Separate Shower, & Dual Vanities - PLUS 2 Walk-In Closets! Big Secondary Bedrooms! Enormous 3rd Floor Enclosed Gameroom w/Adjoining Full Bath & Closet - Use as 4th Bedroom/Guest Suite if Desired! Private Paver Patio Area! Fabulous Garden District Location - Within Walking Distance to Town Center, Market Street, Cynthia Woods Mitchell Pavilion, & Hughes Landing!' ,`Acres` = '0.0466' ,`Area` = '15' ,`BuilderName` = '' ,`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` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S969100 - WDLNDS EASTGATE AT EAST SHORE, BLOCK 3, LOT 5' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '2031' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '5935' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Eastgate At East Shore' ,`TaxAmount` = '15936' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419347' WHERE `Matrix_Unique_ID` = '214624186' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T19:22:01.200' ,`MLSNumber` = '78988691' ,`ListAgentFullName` = 'Jean Roberts' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734455' ,`Longitude` = '-95.457237' ,`PhotoCount` = '30' ,`PostalCode` = '77027' ,`RoomCount` = '8' ,`ListPrice` = '1179000.00' ,`Status` = 'Active' ,`StreetName` = 'Shetland' ,`StreetNumber` = '4727' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable renovation from award-winning Impact Design, located in highly desirable Afton Oaks. This home has been beautifully remodeled from the studs, now featuring raised/vaulted ceilings in the living, dining, and primary bedroom. The floor plan has been redesigned with an open layout, 3-4 bedrooms & 3 full baths. New (2022) electrical, plumbing, insulation, furnace, ductwork, tankless water heater, double-pane windows. Gorgeous kitchen has a spacious island/breakfast bar with Quartzite countertop, glass herringbone backsplash, stainless appliances, dual temp wine frig, under cabinet lighting. Beautiful wood flooring throughout. New French doors in the living room and primary bedroom. Fantastic curb appeal featuring new landscaping & front walkway with pavers & crushed gravel. Spacious back yard features new patio, & back/side fence with ample room for a pool. Ideal location near River Oaks District, Highland Village, The Galleria and Uptown Park. NOT IN 100 OR 500 YR FLOOD PLAIN.' ,`Acres` = '0.2107' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Royden Oaks/Afton Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 AFTON OAKS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Afton Oaks' ,`TaxAmount` = '18640' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419347' WHERE `Matrix_Unique_ID` = '214624650' --> 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','214670670','1668419348','214670670','2022-11-13T19:08:58.260','13415580','Margot Perez','Taylor Real Estate Group, Inc.','','','29.708114','-95.360410','44','77021','0','1249000.00','Active','Rio Vista','3702','Street','Houston','4','2','4','3977','Single-Family','One-of-kind stately home located in sought after Riverside Terrace! Freshly updated with new paint throughout, new cabinetry, built-in shelfs, covered porch, patio deck, 2 working fireplaces, designer lighting, epoxy garage floor and more!!! The kitchen chef\'s delight kitchen features counter space galore with island with breakfast bar for 6 guests, state-of the-art appliances and dry bar has wine/beverage cooler. Dining room steps out to newly covered patio and overlooks grand pool with added patio deck with shading. Living room is spacious for entertainment and made to function gas FP. Primary suite features soaring ceilings and electric glowing FP with TV above. New vanities in primary bathroom, huge shower, soaking tub and walk-in closet. 1st floor study, 2nd Fl has family/game room, and 3 bdrms and 1st Fl study. A breezeway down is the glorified guest quarters, LR/Kit/DR/2 Bdrm/2 Bth! 4-car garage with circular driveway. Sellers are relocating!! A must see!!!','0.3099','4','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','2','Riverside','Central Gas','0','LT 15 BLK 69 RIVERSIDE TERRACE SEC 13','Other','13500','Appraisal District','','','0','','4','Convection Oven,Double Oven','1','Gunite','','Gas Cooktop','','Composition','27 - Houston','LOCKHART ELEMENTARY SCHOOL','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal','2','Traditional','Riverside Terrace Sec 13','13312','2.3307','Public Sewer,Public Water','1936','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:35:20.650' ,`MLSNumber` = '66127618' ,`ListAgentFullName` = 'Lidia Tripputi' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.878366' ,`Longitude` = '-95.421300' ,`PhotoCount` = '6' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Randolph' ,`StreetNumber` = '910' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1393' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SCHEDULE A TOUR WITH YOUR REALTOR TO SEE THIS CHARMING HOME. APPLIANCES AND SOME FURNITURE ARE FOR SALE.' ,`Acres` = '0.1887' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 379 BLK 22 LINCOLN CITY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OSBORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lincoln City 3' ,`TaxAmount` = '3711' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419348' WHERE `Matrix_Unique_ID` = '214682543' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:03:20.330' ,`MLSNumber` = '22856634' ,`ListAgentFullName` = 'Jay Thomas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839505' ,`Longitude` = '-95.305113' ,`PhotoCount` = '25' ,`PostalCode` = '77016' ,`RoomCount` = '7' ,`ListPrice` = '244900.00' ,`Status` = 'Active' ,`StreetName` = 'Lanewood' ,`StreetNumber` = '8699' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make cherished new memories in this charming 3-bedroom, 2-bathroom home in the community of Laura Koppe Place. This recently built 2014 property boasts a brick elevation, high ceilings, tile flooring, and an open great family room. Spend quality time in the kitchen, complete with granite countertops, a tile backsplash, and breakfast bar. High ceilings, tile flooring throughout the primary areas. The relaxing primary suite features a walk-in closet, vanity with knee space, extended walk-in shower. Enjoy plenty of space for outdoor entertainment and leisure in the expansive backyard, custom built chicken coop, outdoor patio room with a gas connection for a BBQ grill. Located along I-69 and I-610, commuters have a straight shot to Downtown Houston and the Texas Medical Center. Residents love the easy access to dining, shopping, and entertainment in the Fifth Ward, Midtown, and Downtown. Schools are zoned to Houston ISD. No flooding' ,`Acres` = '0.3857' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 104 BLK 4 LAURA KOPPE PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8407' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Laura Koppe Place' ,`TaxAmount` = '7460' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419348' WHERE `Matrix_Unique_ID` = '214687869' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T20:57:01.947' ,`MLSNumber` = '81921547' ,`ListAgentFullName` = 'Wilfred Broussard' ,`ListOfficeName` = 'Broussard\'s Real Estate Invest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798108' ,`Longitude` = '-95.191015' ,`PhotoCount` = '20' ,`PostalCode` = '77015' ,`RoomCount` = '6' ,`ListPrice` = '214000.00' ,`Status` = 'Active' ,`StreetName` = 'Edgeton' ,`StreetNumber` = '326' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely One Story Traditional Home in the exclusive Woodforest West subdivision. This one is located on a Cul-de-sac street surrounded by well manicured homes. Edgeton has a open floor plan highlighted by two formals. The condenser and furnace was recently per owner. You will just love the sunroom right off the primary bedroom.' ,`Acres` = '0.1641' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 82 WOODFOREST SEC 21' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'GREEN VALLEY ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '3798' ,`TaxRate` = '2.5294' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419348' WHERE `Matrix_Unique_ID` = '214688089' --> 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','214722690','1668419348','214722690','2022-11-13T20:31:26.233','10409172','Mary Beth Brennan','R.E. Wise,LLC','','','29.835310','-95.448300','50','77018','7','489900.00','Active','Viking','2007','Drive','Houston','2','0','3','1896','Single-Family','Welcome to Oak Forest. This home boasts prideful ownership and tasteful upgrades. Located near the highly sought-after Houston Heights area including nearby parks and local dining. This home speaks for itself. Features 3 bedrooms, 2 Bathrooms, Hardwood floors, Granite Countertops, workshop, and much more. Call for a tour today!','0.1653','9','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Oak Forest East Area','Central Gas','0','LT 9 BLK 3 OAK FOREST SEC 18','Subdivision Lot','7200','Appraisal District','','','0','','1','Freestanding Oven','0','','','Freestanding Range','','Composition','27 - Houston','STEVENS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch','Oak Forest Sec 18','9417','2.3307','Public Sewer,Public Water','1954','Appraisal District'); --> New record created successfully