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-09-15T01:22:00.707' ,`MLSNumber` = '31527753' ,`ListAgentFullName` = 'Suzann Richardson' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764092' ,`Longitude` = '-95.474454' ,`PhotoCount` = '45' ,`PostalCode` = '77056' ,`RoomCount` = '12' ,`ListPrice` = '1825000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodway' ,`StreetNumber` = '5530' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4537' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant traditional 5 bedroom brick home situated on a large 16,012sf lot in Broad Oaks. The first floor was designed for entertaining! The inviting reception hall opens to the spacious, light-filled living room with windows on three sides and a gas log fireplace, and to the oversized dining room, perfect for large or small gatherings. On the east side of the home, the island kitchen has it all, gas cooktop, double ovens, SubZero paneled refrigerator and tons of counter and cabinet space. It opens to the cozy family room with a fireplace and to the breakfast area. Upstairs spacious main bedroom with vaulted ceilings, fireplace, en suite bathroom and two walk in closets. Four light-filled secondary bedrooms, one of which is set up as an office/study. Third floor game room. Enjoy the outdoors either on the brick patio with outdoor kitchen, sitting and dining areas with water fountain, or in the expansive professionally landscaped yard. Wonderful parking behind gates. A fine home!' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TR 14B BLK 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '16012' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '635' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Broad Oaks' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710682' WHERE `Matrix_Unique_ID` = '204319067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T01:26:16.200' ,`MLSNumber` = '41596854' ,`ListAgentFullName` = 'Tina Wilcher' ,`ListOfficeName` = 'Century 21 ExclusiveProperties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.761743' ,`Longitude` = '-95.768979' ,`PhotoCount` = '38' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Warmstone' ,`StreetNumber` = '23003' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will love this fabulous home in Cinco Ranch! Beautiful hardwoods in the formal living/dining combo, family, and primary bedroom. Tile in entry, kitchen, breakfast, utility, and primary bathroom. Oversized shower in the primary bathroom. This home has a wonderful flow with natural light from the many expansive windows! Custom drapes and curtains adorn the windows (and stay with the house). Landscaped corner lot has a private backyard with blossoming flowers and mature trees! Gourmet kitchen with ample cabinets and large breakfast room. Frig, washer, and dryer are all included! You will fall in love with the large game room located on the second floor! The owner is downsizing, home furnishings are for sale! Removal of shoes during showings is MANDATORY.' ,`Acres` = '0.1866' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 CINCO RANCH MEADOW PLACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8129' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FIELDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cinco Ranch Meadow Place Sec 0' ,`TaxAmount` = '7972' ,`TaxRate` = '2.6083' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710682' WHERE `Matrix_Unique_ID` = '207445736' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T01:22:00.707' ,`MLSNumber` = '77931766' ,`ListAgentFullName` = 'Jude Ulogo' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.536870' ,`Longitude` = '-95.740402' ,`PhotoCount` = '31' ,`PostalCode` = '77469' ,`RoomCount` = '10' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Rainswept Pass' ,`StreetNumber` = '527' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2321' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW AC JUST INSTALLED 08/22/22 WITH NEW CARPET! Located in Summer Lakes on a cul-de-sac lot within walking distance to the pool, lake and recreation areas. Kitchen features granite counters and island, perfect for the Chef! Vaulted ceiling in the living space which offers a corner fireplace. The game room has closets on both sides for extra storage. Enjoy sitting out on your back patio - no rear neighbors!' ,`Acres` = '0.1716' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER LAKES SEC 1, BLOCK 3, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summer Lakes Sec 1' ,`TaxAmount` = '6531' ,`TaxRate` = '2.8448' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710682' WHERE `Matrix_Unique_ID` = '209114987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T01:22:00.707' ,`MLSNumber` = '97868343' ,`ListAgentFullName` = 'Madison Mutina' ,`ListOfficeName` = 'Paula Mutina Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.178079' ,`Longitude` = '-95.452166' ,`PhotoCount` = '36' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Laurel' ,`StreetNumber` = '1278' ,`StreetSuffix` = 'Loop' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1903' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hot new listing in Heritage Court! Walk up to this peaceful and inviting front porch. The spacious entryway overlooks the beautiful formal dining room with raised ceilings and bright windows. The floor plan has an excellent flow for entertaining. Fabulous kitchen with breakfast bar perfect for quick morning meals, majestic white granite, breakfast area, large living room with corner fireplace with remote, three bedrooms two bathrooms with oversized master, large walk-in closet for storage, two car garage, indoor utility, out back is a covered patio with a custom fenced dog run, rocked area for outdoor fire pit, privacy fence, pecan, mandarin and peach trees in back yard, all brick exterior, beautifully landscaped. Call today for your private showing.' ,`Acres` = '0.2943' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HERITAGE COURT SEC 3 (A0380 J DE J VALDERAS) BLK 1 LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Court Sec 3 A0380 J' ,`TaxAmount` = '6424' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710683' WHERE `Matrix_Unique_ID` = '209269275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T00:43:58.047' ,`MLSNumber` = '28676718' ,`ListAgentFullName` = 'Gada Al Edan' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.530185' ,`Longitude` = '-95.402162' ,`PhotoCount` = '50' ,`PostalCode` = '77578' ,`RoomCount` = '11' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayberry Ridge lane' ,`StreetNumber` = '4435' ,`StreetSuffix` = '' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3161' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the beautiful 2- story home located in Pomona. Enter through the front door and discover a nice entrance to the dining room. The kitchen is featuring built-in stainless steel appliances, granite counter tops, a butler\'s pantry, and an oversized island. The family room hosts a breathtaking 2-story ceiling that is sure to impress. Host a game night in the upstairs game room that overlooks the family room. There is a bedroom downstairs with a bathroom right next to it, in addition to the master bedroom. Thank you for showing our listing.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 3' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '6522' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'POMONA SEC 4' ,`TaxAmount` = '16091' ,`TaxRate` = '3.6594' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710683' WHERE `Matrix_Unique_ID` = '209791667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T01:22:00.707' ,`MLSNumber` = '68937998' ,`ListAgentFullName` = 'Brandi Gullahorn' ,`ListOfficeName` = 'RJ Williams & CompanyR J Williams and Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815214' ,`Longitude` = '-95.535151' ,`PhotoCount` = '26' ,`PostalCode` = '77080' ,`RoomCount` = '9' ,`ListPrice` = '729000.00' ,`Status` = 'Active' ,`StreetName` = 'Emnora' ,`StreetNumber` = '9819' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled home in the Spring Shadows neighborhood. Talk about a dream, this home has everything you could need & more! Open concept floor plan with over 3,800 square feet. A spacious chef\'s kitchen featuring quartz countertops, an oversized island, new stainless steel appliances, THREE ovens and a gas range. Beautiful light wood flooring throughout, double sliding glass doors that lead to your backyard pool oasis and covered patio. Downstairs features a study, 2 bedrooms and the primary suite that features an incredible en suite bathroom with an oversized walk-in closet. Upstairs includes a game room/flex room, two more bedrooms, a full bath and closets for extra storage space. Rest assured this fully remodeled home includes updated plumbing, HVAC and electrical as well. **APPLIANCE PACKAGE OFFERED WITH FULL PRICE OFFER. ' ,`Acres` = '0.202' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 6A SPRING SHADOWS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING SHADOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Shadows Sec 05' ,`TaxAmount` = '8543' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663710683' WHERE `Matrix_Unique_ID` = '210630877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T01:22:00.707' ,`MLSNumber` = '35257763' ,`ListAgentFullName` = 'Patricia Taylor' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.066982' ,`Longitude` = '-95.498059' ,`PhotoCount` = '47' ,`PostalCode` = '77566' ,`RoomCount` = '6' ,`ListPrice` = '747685.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou' ,`StreetNumber` = '2202' ,`StreetSuffix` = 'Drive' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning and exceptional custom-built home is filled with original elements expected in a Mastercraft Builder’s Home. This home’s traditional styling and original, timeless design elements are second to none. Thoughtful and complex design components blend its meticulous and modern features with sophisticated comfort. The harmonious design keeps both relaxation and function in perfect balance, whether indoors or outdoors. With a precise building and superb construction approach, the builder/owner has honored the home\'s character by seamlessly blending impeccable craftsmanship and traditional character with modern lifestyle amenities. Every detail was carefully selected and quality crafted.\r\n\r\nFabulous - Timeless - Sophisticated - Functional. Any, or all, of these words, can accurately describe this gorgeous and quality-built home at 2202 Bayou Drive (County Road 682G) Lake Jackson.' ,`Acres` = '1.06' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 22 (1.06 Acres)' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Mill East' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710683' WHERE `Matrix_Unique_ID` = '210676930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T01:22:00.707' ,`MLSNumber` = '80236285' ,`ListAgentFullName` = 'Emily Guillen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000171' ,`Longitude` = '-95.682005' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '10' ,`ListPrice` = '1045500.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Turkey' ,`StreetNumber` = '17111' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The best of both worlds, large acre lot 3 Bedrooms/3.5 baths on the main house. Guest room with full bath in the back of the garage, half bath in the pool area. It has 6 cars plus an RV garage. Gunite pool, outdoor kitchen, sprinkler system, tile roof, small horse stable, wine cellar, french drain security cameras, and custom-built master closet. The HOA is only $75 per year no MUD taxes, and zone to wonderful CFISD schools. The home was custom built in 2010 with open concept, tile and engineering wood floors, the cast iron double door at the entry, and a single cast iron door at the carport area. This is a must-see house. To view, this property call, me or your agent.' ,`Acres` = '1' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 CYPRESS FIELDS SEC 2 U/R R/P' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'A ROBISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Cypress Fields Sec 02 U/R R/P' ,`TaxAmount` = '14065' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710683' WHERE `Matrix_Unique_ID` = '210741174' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T00:26:18.287' ,`MLSNumber` = '57045613' ,`ListAgentFullName` = 'Kashmir Cortave' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.142464' ,`Longitude` = '-94.896609' ,`PhotoCount` = '29' ,`PostalCode` = '77535' ,`RoomCount` = '9' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 662' ,`StreetNumber` = '264' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.961' ,`Area` = '52' ,`BuilderName` = 'Building Beauties' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ENCINO ESTATES, SEC 1, BLOCK 7, LOT 1, ACRES .961' ,`LotDesciption` = 'Corner' ,`LotSize` = '41861' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Encino Estates, Sec 1' ,`TaxAmount` = '1000' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710683' WHERE `Matrix_Unique_ID` = '210856968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T01:22:00.707' ,`MLSNumber` = '24810970' ,`ListAgentFullName` = 'Ina Perlman' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768706' ,`Longitude` = '-95.472989' ,`PhotoCount` = '31' ,`PostalCode` = '77056' ,`RoomCount` = '10' ,`ListPrice` = '1395000.00' ,`Status` = 'Active' ,`StreetName` = 'Broad Oaks' ,`StreetNumber` = '84' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All the comforts of home in this beautiful,elegant patio home,located in Houston\'s prestigious Tanglewood area of Broad Oaks. Built by Lovett,1996, the home has been meticulously cared for and is in pristine condition. Through the years, the owners have updated the kitchen and baths and finished out the 3rd flr,including expanding the stairway and adding a 4th bath with wheelchair access. Recent water heaters (3rd fl tankless ), Roof 2020, Windows Sept 2016-Jan, 2017.( per Seller) All rooms are gracious in size and light and bright! Hardwood flrs, elevator shaft,plantation shutters, gas fireplace (recently redone),high ceilings, electric driveway gate. You\'ll love the large primary bedrm with attached study, two walk-in closets, ensuite bath.The owner spends a lot of loving time in the gourmet, island kitchen and says, \" it works\" .Appliances include Blue Star gas stove, double ovens, warming drawer,Bosch dishwasher. Enjoy entertaining /dining on the invitingly beautiful outside patio.' ,`Acres` = '0.1084' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TR 1E BLK 1 BROAD OAKS R/P' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '4720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Broad Oaks Add' ,`TaxAmount` = '25980' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710683' WHERE `Matrix_Unique_ID` = '210876418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T01:22:00.707' ,`MLSNumber` = '91654142' ,`ListAgentFullName` = 'Callee Maglothin' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806117' ,`Longitude` = '-95.549793' ,`PhotoCount` = '45' ,`PostalCode` = '77043' ,`RoomCount` = '9' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Mallard' ,`StreetNumber` = '1826' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this wooded, oversized lot tucked away on a quiet street & walking distance to Nob Hill Park. This home has been stunningly renovated & features a white/open concept kitchen w/ farmhouse sink overlooking the yard, gas range, soft close cabinets, Quartz countertops & cozy breakfast nook. You will love the storage in the enlarged mud room. The living room is a great place to entertain with brick gas fireplace, charming built-ins, wood flooring, and neutral paint. The formal dining area is a great flex room and could be a home office or game room. Oversized lot features a patio for entertaining with string lights, side yard areas, a separate shed for more storage, and a luxurious hot tub. Some important upgrades include Plantation shutters, PEX plumbing throughout, roof (2019), HVAC (2017), New Ductwork, Dual paned windows (90% of the home), recessed lighting. Your move-in ready home awaits you!' ,`Acres` = '0.2521' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 NOB HILL SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Nob Hill' ,`TaxAmount` = '9522' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710684' WHERE `Matrix_Unique_ID` = '211008550' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T00:15:56.337' ,`MLSNumber` = '17036562' ,`ListAgentFullName` = 'Tamesha Wells' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.604101' ,`Longitude` = '-95.356756' ,`PhotoCount` = '34' ,`PostalCode` = '77047' ,`RoomCount` = '9' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Portman Glen' ,`StreetNumber` = '3919' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2223' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'We recommend you take a look at this home! It is a beautiful 2 story, 3 bedroom possible 4 bedroom home that has been upgraded and won\'t be on the market long! There is plenty of space in the backyard, one of the biggest in the area. The master bedroom is well sized with two large secondary bedrooms both with good-sized closets. It would be easy to turn the upstairs game room into a 4th bedroom, as it has plenty of closet space. Belt 8, Downtown, and Med-Center are all easily accessible.' ,`Acres` = '0.121' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 BRUNSWICK LAKES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '520' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brunswick Lakes' ,`TaxAmount` = '5288' ,`TaxRate` = '2.6498' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710684' WHERE `Matrix_Unique_ID` = '211194165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T01:22:00.707' ,`MLSNumber` = '33701363' ,`ListAgentFullName` = 'Amy Chance' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.969053' ,`Longitude` = '-94.011110' ,`PhotoCount` = '23' ,`PostalCode` = '77627' ,`RoomCount` = '4' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Memphis' ,`StreetNumber` = '3003' ,`StreetSuffix` = 'Avenue' ,`City` = 'Nederland' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3075' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home on a corner lot in the Heart of Nederland! Completely remodeled and modernized. Open concept living space with oversized kitchen and dining area. Step inside the living room and cozy up next to the shiplap wall with beautiful built-ins and an electric fireplace! This home was built for entertaining! Tons of storage and counter space in the kitchen, ready for the chef of the house! Around the corner is a second living or dining space that looks out onto the covered patio and outdoor oasis. No need to leave in order to enjoy the great outdoors - inground pool with slide and hottub, along with designer landscaping and several outdoor seating and lounge areas. Upstairs you will find an additional bedroom, full bathroom, and living space along with private access and balcony. Too many amenities to list them all.' ,`Acres` = '0.2975' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HELENA PARK 3 LT 28 & E36\' OF LT 27 BLK 6' ,`LotDesciption` = 'Corner' ,`LotSize` = '12960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '152 - Nederland' ,`SchoolElementary` = 'HELENA PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEDERLAND HIGH SCHOOL' ,`SchoolMiddle` = 'WILSON MIDDLE SCHOOL (NEDERLAND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Helena Park 3' ,`TaxAmount` = '6703' ,`TaxRate` = '2.4292' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710684' WHERE `Matrix_Unique_ID` = '211585276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T01:22:00.707' ,`MLSNumber` = '15612556' ,`ListAgentFullName` = 'Linda Coursey' ,`ListOfficeName` = 'Sky Real Estate Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981357' ,`Longitude` = '-95.601343' ,`PhotoCount` = '49' ,`PostalCode` = '77070' ,`RoomCount` = '6' ,`ListPrice` = '408000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenway' ,`StreetNumber` = '11918' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Welcome home! This gorgeous home is located in the highly sought out established subdivision of Lakewood Forest. 2-story home has been beautifully updated with all new flooring, new fixtures thru out, new kitchen featuring new stainless-steel appliances, dazzling quartz countertops thru out. Home offers 3,385 sqft of living space, 4 beautiful, spacious bedrooms, 3 and ½ bathrooms, a bright and inviting living area, study and an upstairs game room! Zoned to Highly Accredited Cy-Fair ISD. Make an appointment TODAY!' ,`Acres` = '0.2112' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 16 LAKEWOOD FOREST SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '655' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest Sec 08' ,`TaxAmount` = '6381' ,`TaxRate` = '2.3988' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710684' WHERE `Matrix_Unique_ID` = '211666588' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-15T01:22:00.707' ,`MLSNumber` = '94401037' ,`ListAgentFullName` = 'Dana Johnson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770537' ,`Longitude` = '-95.518619' ,`PhotoCount` = '41' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '4350000.00' ,`Status` = 'Active' ,`StreetName` = 'Piney Point' ,`StreetNumber` = '621' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '4' ,`BedsTotal` = '5' ,`SqFtTotal` = '9253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous New England style estate on over an acre with a serene, private atmosphere and fantastic features throughout. Gated entry and long private driveway leads to two circle driveways, up to a porte-cochère and detached three car garage. Recently updated home is hidden gem and set back from the street. Grand front entry and high ceilings with stunning wide plank, gorgeous heart pine flooring throughout the first floor. Recently updated open-concept kitchen with large island opens to family room overlooking the lush backyard with oversize saltwater pool and fountains. Updated primary retreat was taken to the studs and is elegant and modern. Primary features an updated en-suite, and double closets. Four additional bedrooms upstairs plus a game room and media room. A peaceful retreat is located in the heart of Piney Point and is centrally located.' ,`Acres` = '1.185' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 RAYBURN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '51618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'English,Other Style' ,`Subdivision` = 'Rayburn' ,`TaxAmount` = '65509' ,`TaxRate` = '2.1721' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710684' WHERE `Matrix_Unique_ID` = '211734130' --> 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','212018406','1663710684','212018406','2022-09-15T01:22:00.707','69051802','Cheryl Ford','Martha Turner Sotheby\'s International Realty','','','29.748938','-95.548344','22','77042','8','549000.00','Active','Briarpark','1303','Drive','Houston','2','1','3','2278','Single-Family','Wonderful opportunity on the North side of coveted Briargrove Park. This 3 bedroom, 2 1/2 bathroom home backs up to Rivercrest and sits on a wooded lot. This lovingly cared for home has gorgeous curb appeal, oversized bedrooms and a generous Kitchen/breakfast area. This home features a sprinkler system, gas fireplace, HVAC(2020), Outside Condensor (2020), water heater(2020) and gas line and valve replaced (2022). Bring your best decorating ideas and make this house your home! This wonderful neighborhood boasts neighborhood pool, park and tennis courts. Private security provided by HOA and garbage pick up. Close proximity to the Terry Hershey trail and City Centre. This home never flooded!','0.2152','22','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Briargrove Park/Walnutbend','Central Gas','1','LT 442 BLK 15','Subdivision Lot','9375','Appraisal District','','685','0','','2','Double Oven','0','','','Gas Cooktop','','Composition','27 - Houston','WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)','WESTSIDE HIGH SCHOOL','REVERE MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Briargrove Park','12870','2.3307','Public Sewer','1962','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212191733','1663710684','212191733','2022-09-15T01:22:00.707','18755178','Skyler Rogers','Houston Home Store LLC','','','29.856203','-95.346683','15','77093','3','295000.00','Active','Hitchcock','2430','Street','Houston','2','0','3','1200','Single-Family','This home sets a new standard for luxury, completely remodeled from inside & out.\r\nThe interior has been customized by a professional designer, that provides a one of a kind look.\r\nHuge back yard with second car entrance perfect for storage, RV\'s or Trucks.\r\nFully fenced off for optimal privacy, while at the same time located only minutes away from HWY 45, HWY 59, Hardy toll rd and the 610 loop.','0.1869','9','','','','','Sellers Disclosure','1','','0','Northside','Central Gas','0','LT 18 DUNBAR PLACE','Subdivision Lot','8140','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','COOP ELEMENTARY SCHOOL','SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER','PATRICK HENRY MIDDLE SCHOOL','Appointment Required,Lockbox Front','Seller','1','Traditional','Dunbar Place','1693','2.3307','Water District','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212204851','1663710684','212204851','2022-09-15T01:22:00.707','69562764','Courtney Robertson','Compass RE Texas, LLC','','','29.770234','-95.473476','37','77056','13','2599000.00','Active','Point Broad Oak','127','','Houston','5','2','4','7593','Single-Family','Iconic French Normandy architecture designed by Robert Dame on a charming gated street in Broad Oaks. The elegant custom, one-owner home features grand rooms with 12’ ceilings on the first floor, picturesque balconies and a patio you will never want to leave. The open kitchen boasts a large island, 2 dishwashers, double ovens, gas range and a butler’s pantry leading to the dining room. Family room with set of French doors that lead to the covered patio with outdoor kitchen, and yard space. The primary suite has it all, from 2 full bathrooms and walk-in closets to a separate vanity area. Unwind in the gorgeous library featuring a wet bar, private balcony, and pocket door access to the primary suite. Secondary bedrooms are generously sized and all feature ensuite baths with walk-in closets. Other standouts include a 3 car garage with additional storage room, 2 staircases, elevator capable, abundant storage with walk up access on the third floor, home office/flex space, guest parking.','0.233','22','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gaslog Fireplace,Wood Burning Fireplace','3','Tanglewood Area','Central Gas,Zoned','1','LT 9 BLK 1 POINT BROAD OAKS R/P','Subdivision Lot','10151','Appraisal District','','7000','0','','3','Convection Oven,Double Oven','0','','','Gas Range','','Composition','27 - Houston','BRIARGROVE ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','2','French,Other Style,Traditional','Point Broad Oaks R P','53605','2.3307','Public Sewer,Public Water','2007','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212207361','1663710684','212207361','2022-09-15T01:22:00.707','51914548','Sabiha Rehmatulla','Compass RE Texas, LLC','','','29.747649','-95.513445','49','77024','14','7990000.00','Active','Stillforest','40','Street','Piney Point Village','7','3','6','12617','Single-Family','Piney Point custom designed estate by acclaimed architect Robert Dame offers a complete custom living experience with polished details carefully curated for a resort like lifestyle with exceptional amenities such as pool, theater, tennis court, outdoor kitchen with fireplace and gardening house. Situated on 1 sprawling acre of gorgeous grounds. 2-story library with built in shelvings. The formal dining with walk out patio is ideal for hosting formal dinners. Gourmet chef’s kitchen with a large island features custom designed cabinetry and a catering/prep kitchen. Covered outdoor includes kitchen with cabinetry & high-end appliances. Primary suite offers a fireplace, marble bathroom with dual walk in closets and its own private staircase t the gym & study. Additional bedrooms with ensuite bathrooms. This home offers astounding amenities (generator, elevator, Crestron home automation & mosquito control system). The neighborhood has its own security in addition to the Piney Point Police.','0.995','23','','','Washer Connections','','Sellers Disclosure','1','Gas Connections','5','Memorial Villages','Central Gas','1','TR 20 STILL FOREST U/R ABST 72 J D TAYLOR','Wooded','43342','Appraisal District','','2500','0','','4','Double Oven,Gas Oven','1','Heated,In Ground','','Gas Range','','Tile','49 - Spring Branch','MEMORIAL DRIVE ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','Accompany,Appointment Required,No Supra Keybox','Appraisal District','2','Mediterranean','Still Forest #20','99528','2.1721','Public Sewer,Public Water','2013','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212214445','1663710684','212214445','2022-09-15T01:22:00.707','71853250','Brian Spack','Martha Turner Sotheby\'s International Realty','Carolyn Bauerschlag','Keller Williams Premier RealtyKaty','29.749211','-95.530152','50','77024','10','1000000.00','Option Pending','Sugarberry','257','Circle','Houston','2','1','3','3349','Single-Family','In a clearing of the forest that is Hudson Bend, behind a guarded gate is a beautifully updated + expertly curated patio home sure to entice. Tucked away in the rear of the community, this low maintenance, all brick home is at the same time stylish + comfortable. Designer touches abound: striking wallpapers, warm colors + the finest finishes. First floor Living is bright + expansive—the Dining Room swathed in Chinoiserie; the Great Room has a vaulted ceiling, fireplace as it flows into a cozy Den. Updated Kitchen with Morning Room, induction range + great storage. Ride the elevator or climb the stairs to the Bedrooms. Spacious Master Suite has vaulted ceiling, walk-in closet + stunningly updated Master Bath. Gorgeous Secondary Bedrooms share an equally handsomely updated Bath + have large closets. Peerless Back Yard has covered loggia with Summer Kitchen + a berm that connects you with nature. A perfect home in a perfect setting—plus SBISD schools—for what more can you ask?','','23','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','1','Memorial West','Central Gas,Zoned','1','LT 1, HUDSON BEND 2ND AMENDED R/P','Patio Lot','3480','Appraisal District','','1200','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','49 - Spring Branch','MEMORIAL DRIVE ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','Appointment Required','Appraisal District','2','Traditional','Hudson Bend','16671','2.4415','Public Sewer,Public Water','1992','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212397172','1663710684','212397172','2022-09-15T00:06:55.973','13081340','Maria Hernandez','HomeSmart','','','29.848981','-95.230837','10','77078','3','172000.00','Active','Valley Song','8710','Drive','Houston','2','0','3','1346','Single-Family','DO NOT MISS this opportunity to own this 3 bedroom 2 bathrooms at a great price. Updates and repairs needed. Selling AS-IS.','0.1212','2','','','','','Sellers Disclosure','','','1','Northeast Houston','Central Gas','0','LT 115 BLK 4 PARKWOOD EAST SEC 1 R/P','Subdivision Lot','5280','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','ELMORE ELEMENTARY SCHOOL','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Parkwood East Sec 01 R/P','4008','2.3307','Public Sewer,Public Water','1978','Appraisal District'); --> New record created successfully