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-08-31T15:48:29.617' ,`MLSNumber` = '69617521' ,`ListAgentFullName` = 'Rosalva Alvarado' ,`ListOfficeName` = 'Excelencia-Excellence RE, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.195948' ,`Longitude` = '-95.702242' ,`PhotoCount` = '38' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '225900.00' ,`Status` = 'Active' ,`StreetName` = 'PINE BARK' ,`StreetNumber` = '37302' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hurry and ask your agent to schedule a showing for you on this magnificent, totally renovated home. You will not believe your eyes, it shows like a brand new home. This home is the home of your dreams! With an easy flowing floor plan this home was renovated to entertain, with a lot of beautiful details built on site. You will love the custom bar and the recently pour concrete back patio. Must see to appreciate, Hurry! home won\'t last long in the market. measurements are approximate, please verify if needed. Country living at its best, yet this property is close to major highways such as SH-249, FM 1774, 1488 and only a block away from the newly open Aggie expressway.' ,`Acres` = '0.51' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S576008 HAZY HOLLOW EAST EST 08, BLK 60 LT 1 MH SERIAL #8990' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '22216' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Craftsman,Split Level' ,`Subdivision` = 'HAZY HOLLOW EAST ESTATES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705223' WHERE `Matrix_Unique_ID` = '200551932' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:13:29.717' ,`MLSNumber` = '15084362' ,`ListAgentFullName` = 'Linda Jamail Marshall' ,`ListOfficeName` = 'Linda Marshall, Realtors Inc.' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.343959' ,`Longitude` = '-95.524029' ,`PhotoCount` = '13' ,`PostalCode` = '77304' ,`RoomCount` = '3' ,`ListPrice` = '375050.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'YELLOW BIRCH' ,`StreetNumber` = '736' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1895' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WEDGEWOOD FOREST-NEW CONSTRUCTION COMPLETING END AUGUST, GARDEN COVE ELEVATION C FLOORPLAN-THREE SPACIOUS BEDROOMS ALL ON SINGLE FLOOR-FANTASTIC KITCHEN- 3 SIDE BRICK EXTERIOR-VERY FUNCTIONAL FLOORPLAN, ATTRACTIVE FRONT ELEVATION WITH ATTRACTIVE FRONT ENTRY AS WELL AS A COVERED BACK PATIO, NICE LOT. THE MASTER HAS A LUXURIOUS MASTER BATH WITH FREESTANDING TUB AND SEPARATE SEMI FRAMELESS SHOWER, DBL VANITY AREA AND GREAT STORAGE, BIG WALK IN MASTER CLOSET. KITCHEN WITH ITS ATTRACTIVE CABINETS AND GRANITE COUNTER LOOKS TO THE FAMILY ROOM. SECONDARY BEDROOMS SHARE A SPACIOUS BATH AND BOTH HAVE GREAT CLOSET SPACE. COME AND VISIT BUILDER SALES OFFICE (ASK ABOUT ANY SPECIALS)AT 302 PITCHE PINE COURT, CONROE 77304 OPEN HOUSE 10-6 (M-TUES,& FRI), 12-6 (S&S)' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'DH HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 15, BLOCK 3, WEDGEWOOD FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'WEDGEWOOD FOREST' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705224' WHERE `Matrix_Unique_ID` = '205355640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:46:37.363' ,`MLSNumber` = '73530029' ,`ListAgentFullName` = 'Jarred DeMore' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.478579' ,`Longitude` = '-94.578973' ,`PhotoCount` = '6' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Beachcomber' ,`StreetNumber` = '3398' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION COMING SOON IN THE DUNES! 4/2 on huge corner lot! Gorgeous new construction with stainless appliance package. Neutral white/gray tones throughout. Walk into the large living room in front and open kitchen/dining to rear. To the left side of house, you\'ll have a bedroom in front corner and a bedroom in back corner with bath in between. The right side of house will be the same layout! Perfect for rental, vacay or full time living! Awesome neighborhood that\'s close to restaurants, shopping and lots of sightseeing! Floorplan subject to alterations. Golf cart beach access for summer fun! Construction to start upon signed contract.' ,`Acres` = '0.1768' ,`Area` = '33' ,`BuilderName` = 'Ron Rusche' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 PAGE 14 LOT 6 THE DUNES' ,`LotDesciption` = 'Corner' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Dunes' ,`TaxAmount` = '372' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663705224' WHERE `Matrix_Unique_ID` = '206774138' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:30:29.690' ,`MLSNumber` = '69208742' ,`ListAgentFullName` = 'Richard Londow' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936571' ,`Longitude` = '-95.232754' ,`PhotoCount` = '32' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Tranquility Ridge' ,`StreetNumber` = '14911' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1554' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 14911 Tranquility Ridge Court! This fabulous 4 bedroom, 2 bath home is conveniently located 2 minutes from the Sam Houston Tollway and tons of restaurants and shopping options! You\'ll also find several parks, including Lindsay Lyons, Deussen, and Sheldon Lake State Park close by! Located in the Sunset Ridge West community, this home is zoned to great schools with Humble ISD. The inside of this home features a great open floor plan, high ceilings, lovely arch door ways, a breakfast bar, eat-in kitchen and spacious family room. The luxurious Primary bedroom includes a spa-like en suite bathroom with deep soaking tub, separate oversized shower and double sinks. This home won\'t be available for long, so schedule your showing today!' ,`Acres` = '0.1239' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 SUNSET RIDGE WEST SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '5399' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Rdg West Sec 2' ,`TaxAmount` = '5500' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705224' WHERE `Matrix_Unique_ID` = '207614637' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:20:03.060' ,`MLSNumber` = '74775778' ,`ListAgentFullName` = 'Marisol Diaz' ,`ListOfficeName` = 'Greg Flaniken & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.156425' ,`Longitude` = '-95.425540' ,`PhotoCount` = '18' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '178500.00' ,`Status` = 'Active' ,`StreetName` = 'Anderson' ,`StreetNumber` = '816' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this move in ready, adorable and completely remodeled property today! This home has 3 bedrooms with a bonus room that could be used as an additional bedroom or office. Home features new vinyl plank flooring, new carpet in bedrooms, new water heater, new roof installed in 01/2022 with WPI8, new HVAC system, new electrical wiring, new plumbing, new stainless steel appliances, granite countertops and so much more! Schedule your appointment today!' ,`Acres` = '0.1478' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SANDERS (ANGLETON), BLOCK 2, LOT 43' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sanders Angleton' ,`TaxAmount` = '1868' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705224' WHERE `Matrix_Unique_ID` = '208418278' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:52:48.447' ,`MLSNumber` = '55212848' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Chelsea Taveras' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '30.236713' ,`Longitude` = '-95.708310' ,`PhotoCount` = '12' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '298490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'BLACKBRUSH MANOR' ,`StreetNumber` = '14730' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional Open Concept 1 story home with 4 Bedrooms and 2 Full Baths! Features Include Open Concept living w/large dining room open to family room & kitchen! Primary bathroom suite offers huge walk in closet! Features include 30\" Flat panel maple cabinets w/crown molding, exotic granite, 4 burner gas cooktop w/SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the PRIVATE backyard with so much room for a pool! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Mill Creek Estates 02, BLOCK 2, Lot 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'MILL CREEK' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705224' WHERE `Matrix_Unique_ID` = '209180707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:00:41.313' ,`MLSNumber` = '7665371' ,`ListAgentFullName` = 'Paul Grohman' ,`ListOfficeName` = 'Paul Grohman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595762' ,`Longitude` = '-95.282046' ,`PhotoCount` = '40' ,`PostalCode` = '77581' ,`RoomCount` = '5' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Glenda' ,`StreetNumber` = '1110' ,`StreetSuffix` = 'Street' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home that shows pride of ownership. Located in the highly desired Pearland school district. Easy access to Beltway 8, Hwy 45, Pearland Parkway, and shopping/entertainment. Large living and dining areas. Large primary bath, Updates in kitchen include farm sink and higher end double oven (one convection) and stove top. Enclosed bonus room with double doors from den. Nicely landscaped with plenty of trees offering plentiful shade. \r\nRoom dimensions are approximate.' ,`Acres` = '0.2296' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CLEAR CREEK ESTATES SEC II (PEARLAND) BLK 1 LOT 2A-3A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'BARBARA COCKRELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Clear Creek Estates Sec II Pe' ,`TaxAmount` = '4175' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705224' WHERE `Matrix_Unique_ID` = '209256284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:29:47.620' ,`MLSNumber` = '34771960' ,`ListAgentFullName` = 'Nathan Balderas' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701796' ,`Longitude` = '-95.476455' ,`PhotoCount` = '8' ,`PostalCode` = '77081' ,`RoomCount` = '2' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Jessamine' ,`StreetNumber` = '5501' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1177' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Location! This home is close to The Galleria, Downtown, Medical Center and so much more! A Walking distance from Schools and many Bellaire Parks! The sales price may not cover all fees.' ,`Acres` = '0.1972' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 BLK 8 RICHMOND PLAZA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8592' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Richmond Plaza' ,`TaxAmount` = '6817' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705224' WHERE `Matrix_Unique_ID` = '209273330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:38:25.090' ,`MLSNumber` = '3615097' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.678208' ,`Longitude` = '-95.898968' ,`PhotoCount` = '3' ,`PostalCode` = '77441' ,`RoomCount` = '13' ,`ListPrice` = '744000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekbend' ,`StreetNumber` = '4939' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The spacious 1.5-story Azure floor plan was designed with all the essentials for modern living. The open gourmet kitchen has ample counter space, a large island with a rounded countertop, and a walk-in pantry. The dining room and great room are perfect for entertaining friends and family, and a dedicated study area is ideal for those who work from home. The primary bedroom has a spa-like ensuite with double vanities, shower, freestanding tub, and impressive walk-in closet. An upstairs bonus room with a powder room can be used as a game room, entertainment hub, or additional storage space. Thoughtful extra conveniences like mudroom built-ins, utility room cabinets, a modern 60” linear fireplace, and an outdoor kitchen are included.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29, Block 1, Section 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook at Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.99' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705224' WHERE `Matrix_Unique_ID` = '209472423' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:30:42.050' ,`MLSNumber` = '4008923' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807979' ,`Longitude` = '-94.924713' ,`PhotoCount` = '28' ,`PostalCode` = '77521' ,`RoomCount` = '15' ,`ListPrice` = '364990.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset Horizon' ,`StreetNumber` = '8439' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'From the moment you walk through the front door, you will know that this is the one! This stunning two-story Hoover II brick home features 5 bedrooms, 4 baths and 2 car garage. Beautiful maple cabinets and granite countertops with low bar top in kitchen. Elegant dining room overlooks covered patio in backyard. Two bedrooms, including owner\'s suite, located downstairs. Huge walk-in closet, separate tub and shower in owner\'s bath. Upstairs, you\'ll find a cozy activity room and 3 secondary bedrooms. Don\'t miss this home! Offered by: K. Hovnanian of Houston II, LLC.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '21/3/8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7869' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Creek' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705225' WHERE `Matrix_Unique_ID` = '209732157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:26:42.750' ,`MLSNumber` = '93574930' ,`ListAgentFullName` = 'Kariliz Perez' ,`ListOfficeName` = 'Stone & Fields' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.618126' ,`Longitude` = '-95.243051' ,`PhotoCount` = '30' ,`PostalCode` = '77075' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Habitat' ,`StreetNumber` = '9648' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION home near the Hobby Airport! A single family home featuring designer cabinets, quarts counter tops, beautiful vinyl wood looking floors, gas cooktop, stainless steel appliances and modern architecture. Villas at Windmill Lakes is a new community of 65 homes offering 3 different floor plans to choose from and a location like no other. Welcome Home!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'HGC Build' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 3' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'HANCOCK ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Villas at Windmill Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705225' WHERE `Matrix_Unique_ID` = '209970454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:12:07.993' ,`MLSNumber` = '67980145' ,`ListAgentFullName` = 'Trevor Brown' ,`ListOfficeName` = 'Stoneburner & Associates ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804274' ,`Longitude` = '-95.843173' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Savannah' ,`StreetNumber` = '7010' ,`StreetSuffix` = 'Run' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes 6020 floor plan. Home is like new as owners have only occupied the home for a little over 7 months. Home has around $100,000 in upgrades (as per owners) and features a private courtyard leading to the main entrance. Complete exterior brick with back patio wired for external kitchen. Highly acclaimed Katy ISD. Brand new elementary school (Robertson Elementary) opening in the Fall 2022 semester and is a short 10 min walk from the home. Clubhouse with fitness center, yoga room, two swimming pools, splashpad, coffee station, and an upscale restaurant (The Oaks) all within a short walk from the home. This home has an open floor plan with high ceilings and a gas burning fireplace, 3 car tandem garage. Chef\'s kitchen with a large island. Kitchen open to family room with lighting under cabinet. Home has 4 Bed Rm (including 1 guest en-suite perfect for in laws) plus an office. 3.5 baths with primary bath having a large shower and a freestanding soaking tub. Beautiful curb appeal.' ,`Acres` = '0.1934' ,`Area` = '25' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422381 CANE ISLAND SECTION 21 BLK 1 LOT 43 ACRES .1934' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island Sec 21' ,`TaxAmount` = '' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705225' WHERE `Matrix_Unique_ID` = '210355724' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:13:54.347' ,`MLSNumber` = '64318469' ,`ListAgentFullName` = 'Karla Villanueva' ,`ListOfficeName` = 'City Spot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.630850' ,`Longitude` = '-95.256486' ,`PhotoCount` = '6' ,`PostalCode` = '77075' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Radio' ,`StreetNumber` = '9450' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AS IS SALE- Land value only ' ,`Acres` = '0.5034' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 6C-2 BLK 12 SOUTH HOUSTON GARDENS SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21926' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'JESSUP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Houston Gardens Sec 08' ,`TaxAmount` = '4001' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705225' WHERE `Matrix_Unique_ID` = '210359256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:35:45.630' ,`MLSNumber` = '47869386' ,`ListAgentFullName` = 'Nora Cardenas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.281854' ,`Longitude` = '-95.164104' ,`PhotoCount` = '25' ,`PostalCode` = '77328' ,`RoomCount` = '7' ,`ListPrice` = '141500.00' ,`Status` = 'Active' ,`StreetName` = 'Creek Dr' ,`StreetNumber` = '11232' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this opportunity to call this property your home. It\'s a 3 bedroom 2 bathroom double wide manufactured home located in North Woods Subdivision on .36 acres. Property has close access to the highway, shopping centers, and more. Neighborhood is in the Splendora ISD. Lots of potential. Schedule a showing today.' ,`Acres` = '0.36' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'NORTH WOODS 02, LOT 300, MH SERIAL # SCAR196284439667A, TITL' ,`LotDesciption` = 'Cleared' ,`LotSize` = '15682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '30' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'North Woods 02' ,`TaxAmount` = '574' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Sewer,Public Water,Septic Tank' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705225' WHERE `Matrix_Unique_ID` = '210692171' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:14:40.553' ,`MLSNumber` = '78968868' ,`ListAgentFullName` = 'Judith Hayes' ,`ListOfficeName` = 'Designed Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.764883' ,`Longitude` = '-94.965987' ,`PhotoCount` = '47' ,`PostalCode` = '77351' ,`RoomCount` = '9' ,`ListPrice` = '524900.00' ,`Status` = 'Active' ,`StreetName` = 'Horace Bonds' ,`StreetNumber` = '497' ,`StreetSuffix` = 'Road' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Peaceful and private! This stunning custom home is situated on 3.1 partially wooded acres! You will LOVE the stained concrete floors throughout the downstairs! Gourmet kitchen with island, tons of cabinets, walk in pantry, double ovens and granite counters with farm house sink and breakfast bar! Electric two sided fireplace with pivotal TV (which is removable if you want it to be) is situated between the family room and dining room so you get to enjoy it in both areas! Owner\'s retreat in rear of home features a spa like bath with double sinks, lg walk in shower and separate tub plus direct access to the utility room! Jr suite down features built in murphy bed and full private bath; upstairs features two bedrooms both with built in beds/drawers with jack and jill bath; built inn desk in the hallway; bonus room that also has a built in desk - perfect for gaming and relaxing for the kids upstairs. Plantation shutters. Outdoor kitchen and spa on the covered back porch!' ,`Acres` = '3.1' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 9 JOHN D BURKS SURVEY TRACT 16-1' ,`LotDesciption` = 'Wooded' ,`LotSize` = '135036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'John Burks' ,`TaxAmount` = '4613' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705225' WHERE `Matrix_Unique_ID` = '210744736' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:07:14.267' ,`MLSNumber` = '84219086' ,`ListAgentFullName` = 'LaTisha Grant' ,`ListOfficeName` = 'TAS Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560241' ,`Longitude` = '-95.525335' ,`PhotoCount` = '43' ,`PostalCode` = '77459' ,`RoomCount` = '14' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble' ,`StreetNumber` = '1650' ,`StreetSuffix` = 'Brook' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Who said finding your dream home at the right price was impossible? Whoever said that hasn\'t toured 1650 Pebble Brook. Located on a corner lot with mature trees, this exquisite masterpiece is ready for a new owner. Offering laminate wood floors, tile, fireplace in the living room and character you just can\'t find everywhere. This house is priced to allow you room to make it your home.' ,`Acres` = '0.1869' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CRESCENT OAK VILLAGE AT LAKE OLYMPIA SEC 6, BLOCK 3, LOT 58' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '846' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Crescent Oak Village At Lake Olympia' ,`TaxAmount` = '8031' ,`TaxRate` = '2.79' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705225' WHERE `Matrix_Unique_ID` = '210771711' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:35:28.440' ,`MLSNumber` = '42547580' ,`ListAgentFullName` = 'Angela Talley' ,`ListOfficeName` = 'Key 2 Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586954' ,`Longitude` = '-95.232456' ,`PhotoCount` = '13' ,`PostalCode` = '77089' ,`RoomCount` = '9' ,`ListPrice` = '309999.00' ,`Status` = 'Active' ,`StreetName` = 'Sageyork' ,`StreetNumber` = '11010' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2158' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '• BUILT MID 70\'S\r\n• APPROXIMATELY 2200 SQ FT\r\n• 4 BEDROOM, 2 BATH, 2 CAR GARAGE\r\n• BREAKFAST NOOK, DINING ROOM, DEN, LIVING ROOM, MASTER DOWN, 3 BEDROOMS & BATH UPSTAIRS\r\n• NEUTRAL PALLET\r\n• ROOF (25 YR) 2008\r\n• REMODELED (NEW SHEETROCK, PAINT, KITCHEN CABINETS, TUBS, COMMODES, INSULATION ENTIRE \r\n HOUSE TILED) 2010\r\n• NEW AC, DUCTING 2016\r\n• HARDIE SIDING AND EXTERIOR PAINT & INTERIOR TOUCH UP 2022' ,`Acres` = '0.1798' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 5 SAGEMEADOW SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7830' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FRAZIER ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sagemeadow Sec 01' ,`TaxAmount` = '4775' ,`TaxRate` = '2.6355' ,`WaterSewer` = 'Public Sewer,Public Water,Septic Tank' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705226' WHERE `Matrix_Unique_ID` = '210855845' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:06:18.780' ,`MLSNumber` = '76749819' ,`ListAgentFullName` = 'Sheron Jones' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.879430' ,`Longitude` = '-95.287836' ,`PhotoCount` = '30' ,`PostalCode` = '77016' ,`RoomCount` = '11' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Tamworth' ,`StreetNumber` = '11106' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is truly a must see! This fabulous 4-bedroom, 2 full bath home has Upgrades inside and out! You will find that this home has been upgraded with wood flooring in all common areas and new carpet in all bedrooms. There is a Large primary bedroom with a full bath that has a Frameless Shower with upgraded tile. New faucets and fixtures are throughout the home. Home has 3 new air conditioning systems. Not to mention the huge media room for all your family gatherings. Sprinkler system recently installed. Covered patio. You will enjoy having 3 garages with one oversize garage door for boat or large equipment storage. Don\'t miss out. Schedule your private showing right away!' ,`Acres` = '0.154' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 BLK 52 NORTHWOOD MANOR SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Northwood Manor Sec 06' ,`TaxAmount` = '1474' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705226' WHERE `Matrix_Unique_ID` = '210863654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:42:20.847' ,`MLSNumber` = '24157101' ,`ListAgentFullName` = 'Christina Osborne' ,`ListOfficeName` = 'Houston Realty Team' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.493845' ,`Longitude` = '-95.150639' ,`PhotoCount` = '45' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Oak' ,`StreetNumber` = '301' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! TAKE A LOOK AT THIS HOME! IT HAS EVERYTHING YOU MIGHT WANT. PRIVATE/GATED COMMUNITY ***NO MUD TAXES*** NEW ROOF & NEW AC. 5 BEDROOMS WITH A BONUS ROOM THAT COULD BE AN EXTRA BEDROOM, MEDIA ROOM, OFFICE, OR WORKOUT ROOM. PLUS A GAME ROOM UPSTAIRS AS WELL! THIS HOME OFFERS BOTH FORMALS, LARGE OVERSIZED WINDOWS, A FIREPLACE, & A LARGE PRIMARY BEDROOM AND BATHROOM WITH A WALKING CLOSET DOWNSTAIRS. THE SECOND BEDROOM DOWNSTAIRS HAS DIRECT ACCESS TO A BATHROOM WHICH IS SHARED WITH GUESTS! THE KITCHEN OFFERS GRANITE COUNTERTOPS, OFFICE SPACE, & LOTS OF CABINETS FOR STORING ALL OF YOUR KITCHEN APPLIANCE NEEDS. THE BACKYARD OFFERS LOTS OF SPACE FOR ENTERTAINING, CORNER LOT, PLUS A 3-CAR GARAGE! LOTS OF ROOM FOR ALL OF YOUR VEHICLES/TOYS. THIS LOCATION IS INCREDIBLE! YOU CAN GET TO I45, SHOPPING, SCHOOLS, AND RESTAURANTS WITHIN MINUTES! WALKING DISTANCE TO THE COMMUNITY POOL, PARK, AND NICE SIDEWALKS FOR YOUR DAILY RUNS/WALKS. LOCATION, LOCATION, LOCATIONS! PLUS INCREDIBLE HOME!' ,`Acres` = '0.2141' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 PAGE 9 & 10 LOT 1 BLK 3 OAK CREEK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Creek Sec 1 94' ,`TaxAmount` = '8263' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705226' WHERE `Matrix_Unique_ID` = '210872861' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:57:16.617' ,`MLSNumber` = '3432264' ,`ListAgentFullName` = 'Nancy Macias-Morales' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.421918' ,`Longitude` = '-95.120418' ,`PhotoCount` = '50' ,`PostalCode` = '77517' ,`RoomCount` = '11' ,`ListPrice` = '629900.00' ,`Status` = 'Active' ,`StreetName` = 'Veronica' ,`StreetNumber` = '1050' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4078' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious country living exceeds your expectations while maximizing privacy with secluded peacefulness & tranquility. Endless possibilities & exceptional value for a custom craftsman-built home on 2.5 acres.This immaculate custom design floorplan is simply perfect, many upgrades including a 36x36 extended patio,plenty of space for parking. Home boasts an open floor plan, high ceilings, waterproof laminate flooring, recessed lighting, a private office and spacious utility room. Designer kitchen is fully equipped w/a large center island, granite counters, SS appliances, and a walk in pantry.Two story living room fills w/natural light from the wall of windows & offers backyard views.Primary suite located on the 1st floor boasts a spa-like bath w/a walk-in shower, 2 sink vanity & walk-in closet!Everyday is like a quiet vacation when you live here! Away from the bustle and hustle. With no deed restrictions the possibilities are endless.HOME IS MOVE-IN READY & A MUST SEE!Video tour to watch!' ,`Acres` = '2.5' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 16 C W L\'HOMMEDIEU SUR S 166.36 OF N 1/2 OF LOT 32 (32-' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '108900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lhommedieu Sub' ,`TaxAmount` = '17788' ,`TaxRate` = '2.0881' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705226' WHERE `Matrix_Unique_ID` = '210989922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:41:12.907' ,`MLSNumber` = '18279575' ,`ListAgentFullName` = 'Kim Ann Trigo' ,`ListOfficeName` = 'Emerge Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727233' ,`Longitude` = '-95.376538' ,`PhotoCount` = '38' ,`PostalCode` = '77004' ,`RoomCount` = '4' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Blodgett' ,`StreetNumber` = '1914' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern townhouse in the heart of the Texas Medical Center. Perfect first home or investment property with no HOA. Marble counters in the gourmet kitchen, open living & a rooftop patio with 360-degree views looking at downtown and the medical center. The downstairs bedroom is a perfect guest/mother-in-law suite or income producer through a site like Air BnB because it has a separate entry. Be close to downtown, all stadiums, museums & minutes from both 288 and 59.' ,`Acres` = '0.0593' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 BLODGETT AVENUE TERRACE' ,`LotDesciption` = 'Other' ,`LotSize` = '2585' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MACGREGOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Blodgett Ave Terrace' ,`TaxAmount` = '12346' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705226' WHERE `Matrix_Unique_ID` = '210996007' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:10:02.073' ,`MLSNumber` = '66013080' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.616694' ,`Longitude` = '-95.594850' ,`PhotoCount` = '34' ,`PostalCode` = '77478' ,`RoomCount` = '10' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Fairway' ,`StreetNumber` = '2511' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW!!! EXTREME HOME MAKEOVER!!! EVERYTHING HAS BEEN REDONE FROM TOP TO BOTTOM IN THIS SHOWSTOPPER! GORGEOUS EXTERIOR ELEVATION, NEW DOUBLE PANE WINDOWS & NEW ROOF. STUNNING INTERIOR WITH WOOD FLOORS DOWNSTAIRS, HUGE FAMILY ROOM WITH STACKED STONE FIREPLACE AND LARGE PICTURE WINDOWS TO TAKE IN THE VIEWS OF THE POOL. THE KITCHEN IS INCREDIBLE WITH A LARGE ISLAND, CUSTOM CABINETRY FROM FLOOR TO CEILING, QUARTZ COUNTER TOPS AND BRAND NEW APPLIANCES! LUXURIOUS MASTER SUITE WITH 2 HUGE CLOSETS AND AN AMAZING SPA-LIKE MASTER BATH FEATURING FLOATING CUSTOM CABINETS, DOUBLE SINKS, LARGE SHOWER & STAND ALONE TUB. UPSTAIRS FEATURES LARGE SECONDARY BEDROOMS, A BONUS ROOM THAT COULD BE A 5TH BEDROOM OR GAME ROOM, AND 2 FULLY REMODELED BATHROOMS. BACKYARD PARADISE FEATURES A GORGEOUS POOL, GAZEBO, AND MULTIPLE SEATING AREAS! SUGAR CREEK IS A GOLF COURSE COMMUNITY LOCATED MINUTES TO 59 AND 15 MINUTES FROM THE GALLERIA AND IS ZONED TO FANTASTIC FORT BEND SCHOOLS! CALL THE AIDA YOUNIS TEAM TODAY!' ,`Acres` = '0.2238' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 2, BLOCK 9, LOT 46' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '415' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Built Up' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek' ,`TaxAmount` = '7678' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705226' WHERE `Matrix_Unique_ID` = '211206092' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:34:48.037' ,`MLSNumber` = '98667120' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.399667' ,`Longitude` = '-95.505620' ,`PhotoCount` = '36' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '469990.00' ,`Status` = 'Active' ,`StreetName` = 'Cadence Hills' ,`StreetNumber` = '108' ,`StreetSuffix` = 'Loop' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3143' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Master Planned Community located just minutes from I-45, Lake Conroe, & a quick commute to all The Woodlands has to offer. This LIKE NEW 4 bed, 3 bath home w/ 2.5 CAR GARAGE is DRENCHED in LUXURY -- GOURMET kitchen w/ MASSIVE ISLAND, sleek GRANITE countertops, built-in s/s appliances, rich 42\" cabinetry and open to breakfast and family room. Luxury vinyl plank wood flooring stretching through main living & lots of natural lighting. 8 foot interior doors, downstairs bedroom w/ full bath, UPSTAIRS GAME ROOM, & large secondary bedrooms w/ en-suite bath. Private downstairs retreat w/ bay window extension, his & hers split vanities, oversized shower, & soaking tub. Upgraded 20x15 covered back patio -- perfect for entertaining! Community offers parks, rec center, walking trails, tennis, and pools. Zoned to the highly sought-after WILLIS ISD schools! This home is truly stunning...call and schedule your private tour today!' ,`Acres` = '0.179' ,`Area` = '39' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S927104 - The Woodlands Hills 04, BLOCK 1, Lot 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7804' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '11802' ,`TaxRate` = '3.2823' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705226' WHERE `Matrix_Unique_ID` = '211311950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:03:56.357' ,`MLSNumber` = '52159666' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.832957' ,`Longitude` = '-95.166189' ,`PhotoCount` = '29' ,`PostalCode` = '77360' ,`RoomCount` = '6' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald' ,`StreetNumber` = '532' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in the renowned Emerald Bay lakefront community on Lake Livingston, this 3/2 1-story home is priced to sell and won\'t last long! Interior features include a massive family room with a gorgeous brick accent wall + a wood-burning fireplace, large sliding glass doors, a kitchen boasting tons of shelving space + an island, and 3 generously sized bedrooms. The primary bedroom features a private en-suite bath with a walk-in shower. Out the back door is an enormous covered entertainment deck/patio perfect for relaxing and taking in the views that your new home with a lakeview has to offer. Schedule a private tour today!' ,`Acres` = '0.7896' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'EMERALD BAY BLK 2 LOT 19 & 20' ,`LotDesciption` = 'Cleared,Corner,Water View' ,`LotSize` = '34396' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '158' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Emerald Bay' ,`TaxAmount` = '1884' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705227' WHERE `Matrix_Unique_ID` = '211313030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:24:46.427' ,`MLSNumber` = '462922' ,`ListAgentFullName` = 'Dana Sharp' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.129292' ,`Longitude` = '-97.303080' ,`PhotoCount` = '24' ,`PostalCode` = '78602' ,`RoomCount` = '3' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Piney Ridge' ,`StreetNumber` = '209' ,`StreetSuffix` = 'Drive' ,`City` = 'Bastrop' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1863' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOOKING FOR A GREAT INVESTMENT OPPORTUNITY OR STARTER HOME??? HERE IT IS!!! Super cute one-story 3-2-2 sitting on just a little over 1 acre with extra driveway/parking area. This little gem is being sold AS IS for the perfect person to upgrade with their own personal touches and make a great starter home OR turn her into a lucrative investment opportunity and make the newest AIRBNB/VRBO/RENTAL in Bastrop. Minutes from Buc\'ees and beautiful downtown Bastrop. Easy drive via Hwy 71 to Tesla Giga Plant, Austin Bergstrom Airport, Circuit of the Americas (COTA), and downtown Austin. A short drive to Bastrop State Park, Lake Bastrop, and McKinney Falls State Park.' ,`Acres` = '1.043' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINEY RIDGE SEC 1 REPLAT, BLOCK A, LOT 18A, ACRES 1.0430, (R' ,`LotDesciption` = 'Wooded' ,`LotSize` = '45433' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '210 - Bastrop' ,`SchoolElementary` = 'EMILE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BASTROP HIGH SCHOOL' ,`SchoolMiddle` = 'BASTROP MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Piney Ridge' ,`TaxAmount` = '6570' ,`TaxRate` = '2.3744' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705227' WHERE `Matrix_Unique_ID` = '211363207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:00:10.473' ,`MLSNumber` = '76377980' ,`ListAgentFullName` = 'Iris Saldana' ,`ListOfficeName` = 'American Property Realty, LLC' ,`SellingAgentFullName` = 'Iris Saldana' ,`SellingOfficeName` = 'American Property Realty, LLC' ,`Latitude` = '29.977970' ,`Longitude` = '-95.475274' ,`PhotoCount` = '22' ,`PostalCode` = '77014' ,`RoomCount` = '3' ,`ListPrice` = '229000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Repa' ,`StreetNumber` = '13731' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This home has been remodeled just for you. New floors, Kitchens, bathrooms, fresh paint inside and out. Beautifully designed and upgraded throughout. Don\'t miss out on this Gem. Call today to take a tour!' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lt 45 Blk 3 Sablechase sec 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '35' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BENEKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sablechase' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705227' WHERE `Matrix_Unique_ID` = '211414903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T15:20:53.210' ,`MLSNumber` = '3094072' ,`ListAgentFullName` = 'Michael McLeod' ,`ListOfficeName` = 'Brookshire Real Estate' ,`SellingAgentFullName` = 'Raymond Jones' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.752482' ,`Longitude` = '-95.201205' ,`PhotoCount` = '26' ,`PostalCode` = '77364' ,`RoomCount` = '5' ,`ListPrice` = '149000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Northwoods' ,`StreetNumber` = '461' ,`StreetSuffix` = 'Drive' ,`City` = 'Point Blank' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come enjoy the Lake Livingston life at an affordable price. Nestled in the Northwoods Subdivision in Point Blank, TX right outside of Onalaska that includes a private subdivision park and boat ramp. You\'ll find yourself so close to the water you will never want to leave. Sitting on close to a 1/2 acre this home would make the perfect getaway or VRBO investment property. The home offers a little over 800 Sq. Ft. of living space with beautiful hardwood floors throughout. A nice front porch to watch the sunset in the evenings, downstairs You have a wash/utility room, storage space a circle drive and so much more to list you want to see it yourself.' ,`Acres` = '0.4477' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NORTH WOODS #1, BLOCK 4, LOT 3 & 4, ACRES 0.4477' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'North Woods #1' ,`TaxAmount` = '1024' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705227' WHERE `Matrix_Unique_ID` = '211682916' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:21:18.127' ,`MLSNumber` = '12433427' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661316' ,`Longitude` = '-95.010924' ,`PhotoCount` = '25' ,`PostalCode` = '77571' ,`RoomCount` = '7' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Idaho' ,`StreetNumber` = '622' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated 4 Bedroom, 1 Bathroom home in Bay Front. The property features newer cabinetry with granite countertops (quartz pearl white), new tile shower surrounds, new EE and plumbing fixtures. The house features a contemporary floor plan, stainless steel appliances, grey scale paint interior and hardwood resurfaced. Easy to show, cleaned weekly, and schedule today! AC was just serviced. Please review agent remarks and MLS documents. Schedule a showing today!!' ,`Acres` = '0.1722' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 15 & 16 & TR 17A BLK 8 S 10 FT OF LT 17 BAY FRONT TO LA' ,`LotDesciption` = 'Corner' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Front La Porte' ,`TaxAmount` = '2789' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705227' WHERE `Matrix_Unique_ID` = '211782169' --> 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','211911786','1663705227','211911786','2022-08-31T14:17:43.163','73274288','Lisa Sanders','Living Vogue Real Estate','','','29.480960','-94.938666','48','77539','8','419000.00','Active','Dick Bay','1232','Drive','San Leon','2','1','3','1904','Single-Family','Looking for a property with PROVEN Airbnb income? You can live the high life upstairs while renting out the downstairs and an additional six income-producing covered boat slips with lifts! No HOA, so you can even store your RV in front! Perfect income-producing home! Just blocks from Top Water Grill! This fully furnished home sits on the mouth of the deepwater canal leading to Dickinson Bay in the historic city of San Leon. This property features two large living areas, two full kitchens, two full bathrooms, a bar, and a sunroom. Walk outside to the backyard and enjoy a covered patio with a swing, picnic table, fans, smoker, grill, and fire pit. Plenty of seating to relax and enjoy the boats and the water. Imagine fishing and catching crab out of the backyard. It comes furnished and is currently rented out consistently throughout the year. New Roof 2017, new storm windows 2015, New AC 2021, new plumbing 2021, new water heater 2021, boathouse built-in 2013, and over 220 ft of bulkhead.','0.2459','33','','','Washer Connections','','Mud,Sellers Disclosure','1','','','Bacliff/San Leon','Central Gas,Other Heating,Propane','0','ABST 10 A EDWARDS SUR LOT 46 FIESTA ESTATES','Other,Water View,Waterfront','10712','Appraisal District','','','0','','1','Electric Oven','0','','','Gas Cooktop','','Composition','17 - Dickinson','SAN LEON ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Other Style','Fiesta Estates','3507','2.7147','Public Sewer,Public Water,Water District','1987','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:23:43.043' ,`MLSNumber` = '98428804' ,`ListAgentFullName` = 'Anne Stocker' ,`ListOfficeName` = 'Distinctive Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979326' ,`Longitude` = '-95.526299' ,`PhotoCount` = '42' ,`PostalCode` = '77069' ,`RoomCount` = '10' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble Beach' ,`StreetNumber` = '6226' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare 1-story, 3 or 4 bedroom home with pool on Champions Golf Course!! Located on Jackrabbit 18th tee box, you have an exquisite view of 3 fairways! Unique floorplan features flex room to meet your needs. Multiple outdoor living areas. Features travertine and Saltillo tile, separate ice maker in bar, gas stove, double convection ovens, ample storage, heated pool/spa, mosquito control system, 3-car garage, irrigation, zoned HVAC & water heaters, outdoor kitchen, aluminum fence, indoor/outdoor sound. Recent updates: water heater, sprinkler control, pool heater, awnings. Most everything has been replaced/updated/upgraded. Never flooded. Broker/Owner. Seller relocated and drastically reduced the price.' ,`Acres` = '0.2554' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 163 BLK 9 CHAMPIONS SOUTH' ,`LotDesciption` = 'On Golf Course,Subdivision Lot,Wooded' ,`LotSize` = '11125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Champions South' ,`TaxAmount` = '9982' ,`TaxRate` = '2.4906' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705227' WHERE `Matrix_Unique_ID` = '211918404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T14:36:37.483' ,`MLSNumber` = '83728852' ,`ListAgentFullName` = 'Jeremy Mata' ,`ListOfficeName` = 'NetWorth Realty of Houston, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704727' ,`Longitude` = '-95.794160' ,`PhotoCount` = '34' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '699999.00' ,`Status` = 'Active' ,`StreetName` = 'Travis' ,`StreetNumber` = '23918' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come enjoy your morning coffee with a view!! This house sits on the 11th hole of Meadowbrook Farms Golf Course with a Lake View. Once you walk into this updated home you will be greeted with high ceilings through the foyer. The kitchen offers custom built cabinets with quartz countertops that continue throughout the entire home. This 5 bedroom home has plenty of space and storage. All bedrooms down, with a gameroom/media room upstairs with wet bar and half bath. Zoned to Katy-ISD highly acclaimed \"A\" rated schools. Schedule your appointment today!' ,`Acres` = '0.2732' ,`Area` = '36' ,`BuilderName` = 'Emerald Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEVEN MEADOWS SEC 7, BLOCK 3, LOT 11' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot,Water View' ,`LotSize` = '11901' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HOLLAND ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Seven Meadows Sec 7' ,`TaxAmount` = '11666' ,`TaxRate` = '2.5145' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705228' WHERE `Matrix_Unique_ID` = '211969985' --> 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','211973293','1663705228','211973293','2022-08-31T14:57:27.473','82422014','Kimberly Pena','BHGRE Gary Greene','','','30.353428','-95.590640','24','77316','5','285000.00','Active','Mesa','257','View','Montgomery','2','0','4','1657','Single-Family','Welcome to 257 Mesa View. This property is featured with 4 bedroom and 2 full baths. It is zoned to the very sought after Conroe ISD. Home is in a prime location, including across Lake Conroe with many restaurants and shops nearby. Only a quick 20 minute drive to Margaritaville. Come check out this house.','0.1866','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Lake Conroe Area','Central Electric','1','TEJASCREEK 04, BLOCK 3, LOT 11','Other','8128','Appraisal District','','375','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','GORDON-REED ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Tejascreek 04','4126','2.1863','Public Sewer,Public Water','2002','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211988276','1663705228','211988276','2022-08-31T14:13:28.300','14118305','Philip Thomas','Compass RE Texas, LLC','','','30.153470','-95.468996','50','77380','14','4750000.00','Active','Doe Run','25','Drive','The Woodlands','5','3','4','7890','Single-Family','Grand yet intimate estate on rare, private & expansive lot of the TWCC East Course 12th hole. Mins to I-45 Market St shops & restaurants. Built for discerning clientele w/the finest materials. Elegant & traditional elements blending wood, brick, iron & marble. Formal reception foyer w/curvilinear staircase opens to Library & Dining Room. Sun-lit living w/French doors. Gourmet Kitchen features Thermador appliances, steam oven, 80 bottle wine fridge & catering pantry. Magnificent Owner’s Retreat w/spa Bath, custom closets and fireplaces. Large Game Room/Media w/stunning golf course views. Blissful Spa/Gym/Steam shower could be Guest Suite. 2-story Guest Quarters currently an Office. The exterior grounds are equally captivating featuring lush landscape, summer Kitchen, sport court, pool/spa, fire pit. All w/upmost privacy for entertaining. Fenced motor court for 7 cars. Other amenities include 4 car garage, 2 generators, elevator, Control 4. No detail has been spared in its creation.','0.6496','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections','3','The Woodlands','Central Gas','0','S972816 - WDLNDS VIL GROGANS ML 16, BLOCK 4, LOT 1','In Golf Course Community,On Golf Course,Water View','28296','Appraisal District','','','0','','4','Convection Oven,Double Oven','1','Heated,In Ground','','Gas Cooktop,Gas Range,Grill','','Composition','11 - Conroe','LAMAR ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Request Online Appointment','Appraisal District','2','Colonial,Georgian,Traditional','Wdlnds Village Grogans Ml 16','46636','2.0079','Water District','2017','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212012804','1663705228','212012804','2022-08-31T15:16:27.317','66827298','Theresa Frazier','Heart of Texas Real Estate','','','30.946110','-95.914206','34','77864','7','99900.00','Active','Randolph','412','Street','Madisonville','2','0','3','1784','Single-Family','Gem in the rough! Conveniently located on a large 1 acre lot in downtown Madisonville close to restaurants and amenities, this location offers endless possibilities for homeowner or investor. House needs a large scale remodel and the inside has been taken down to the framework. There is also a detached garage/shop on the property. View the pictures or call for details.','1.0174','52','','','','','Sellers Disclosure','','','','Madisonville Area','No Heating','0','MADISONVILLE TOWNSITE BLK 34 35 & 47 (PT) 1.02','Cleared,Subdivision Lot','44320','Appraisal District','','','0','','2','','0','','','','','Composition','175 - Madisonville Consolidated','MADISONVILLE ELEMENTARY SCHOOL','MADISONVILLE HIGH SCHOOL','MADISONVILLE JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','J S Collard League','1161','2.4226','Public Sewer,Public Water','0','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212020226','1663705228','212020226','2022-08-31T15:33:01.303','39028714','Ayodeji Olagoke','Texas Living Company','','','29.659008','-95.341614','44','77033','6','515000.00','Active','Heron','5430','Drive','Houston','2','2','6','2831','Single-Family','Don\'t miss this rare opportunity to claim your charming duplex home. This 1 story tastefully designed masterpiece features open-concept floorplan with spacious interiors, 3 bedrooms, 2 full baths, as well as abundant outdoor living. Gleaming wood like ceramic tile floors through out, loads of windows and custom paint. The kitchen is truly a chef\'s dream with black and stainless appliances, full backsplash, center island and bright recessed lighting. The bathroom offers a spa-like retreat to the homeowner with seamless glass shower. Beautiful countertops with undermount sinks complement tile floor and shower surrounds. A large picture window floods the space in through out the large living and dining areas is ideal for entertaining family and friends. The huge backyard is a nature lover\'s oasis – relax and unwind all year round. Schedule your private tour today!','0.1767','3','Interglobe Homes','','','','Other Disclosures','','','','Medical Center South','Central Electric,Central Gas','0','LT 8 BLK 39 INWOOD TERRACE SEC 6','Subdivision Lot','7695','Appraisal District','','','1','To Be Built/Under Construction','0','','0','','','Gas Cooktop','','Composition','27 - Houston','WOODSON ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','THOMAS MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Inwood Terrace Sec 06','744','2.3307','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212022581','1663705228','212022581','2022-08-31T15:32:46.780','57889912','Kevin Garcia','Coldwell Banker Realty','','','30.400341','-95.504794','36','77318','9','385000.00','Active','Scarlet Maple','123','Court','Conroe','2','1','3','2353','Single-Family','This lovely David Weekley Home combines easy elegance with the streamlined versatility to adapt to your family’s lifestyle changes through the years. Escape to the everyday vacation of your Owner\'s Retreat, which includes a delightful bathroom and a deluxe walk in closet. With an open concept, your living space awaits your interior design style to create the ultimate atmosphere for special occasions and daily life. With a chefs kitchen and large living area your guest will most certainly be entertained. This home is located in the stunning community of The Woodlands Hills which includes miles of walking trails, multiple parks and pools, a community center with gym and entertainment center. Lots of amenities in the area and miles from Lake Conroe! Dont your dream home escape, schedule your showing!','0.1417','39','David Weekly Homes','','Electric Dryer Connections','','Exclusions,Sellers Disclosure','1','','','Lake Conroe Area','Central Gas','1','S927109 - THE WOODLANDS HILLS 09, BLOCK 1, LOT 10','Subdivision Lot,Wooded','6171','Appraisal District','','995','0','','2','Freestanding Oven,Single Oven','0','','','Gas Range','','Composition','56 - Willis','W. LLOYD MEADOR ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','The Woodlands Hills','9240','3.2823','Public Sewer,Public Water','2020','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212027042','1663705228','212027042','2022-08-31T15:27:04.277','31626530','Robert Moore','Perry Homes Realty, LLC','','','30.225615','-95.778739','6','77354','8','489900.00','Active','Wandering Brook','1290','Street','Magnolia','3','0','4','2438','Single-Family','Perry Homes New Construction! Entry welcomes with 12-foot ceiling. Game room and formal dining room frame coffered extended entry. Kitchen and morning area open to spacious family room with wall of windows and a fireplace. Kitchen features corner walk-in pantry and inviting island with built-in seating space. Primary suite includes dual vanity, garden tub, separate glass-enclosed shower and large walk-in closet in primary bath. All bedrooms feature walk-in closets. Extended covered backyard patio. Two-car garage.','','15','PERRY HOMES','','','','Mud','1','','','Magnolia/1488 West','Central Gas','1','S457002 - Escondido 02, BLOCK 1, Lot 38','Subdivision Lot','6000','Unknown','','900','1','To Be Built/Under Construction','2','','0','','','','','Composition','36 - Magnolia','MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Escondido','','3.2','Public Sewer,Public Water','2023','Builder'); --> New record created successfully