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-14T00:20:53.373' ,`MLSNumber` = '7076046' ,`ListAgentFullName` = 'Jessica Rumbaugh' ,`ListOfficeName` = 'Texas Land & Home Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.423018' ,`Longitude` = '-97.559879' ,`PhotoCount` = '9' ,`PostalCode` = '78660' ,`RoomCount` = '12' ,`ListPrice` = '639900.00' ,`Status` = 'Active' ,`StreetName` = 'Calipatria' ,`StreetNumber` = '16905' ,`StreetSuffix` = 'Lane' ,`City` = 'Pflugerville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2973' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully appointed Taylor Morrison home home with no rear neighbors, huge porch for entertaining and backyard firepit is located in the heart of the neighborhood of Carmel - a neighborhood bustling with community activity and minutes across the road from the Elon Musk\'s - The Boring Company. On a lot that backs to dedicated green belt space, head out the back fence gate to the community\'s amenities and miles of trails. Open concept kitchen includes a massive island, stainless appliances and a walk in pantry. Opens into a spacious living and dining space. Carefully thought out design features include an extra half car space in garage, downstairs office or flex room, patio with ceiling fan to enjoy the no rear neighbors view. Conveniently located 2 miles from TX-130, 1.6 miles from Lake Pflugerville. Local schools are 0.6 miles from Carpenter Elementary, 0.7 Bohls Middle School, and 0.9 miles Weiss High School. New roof in 2021, fridge & pool table are negotiable to remain.' ,`Acres` = '0.1593' ,`Area` = '83' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 2 BLK Z CARMEL WEST PHS 2 SEC 3' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '6939' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '117 - Pflugerville' ,`SchoolElementary` = 'RIOJAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HENDRICKSON HIGH SCHOOL' ,`SchoolMiddle` = 'KELLY LANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Carmel' ,`TaxAmount` = '10972' ,`TaxRate` = '2.8535' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698271' WHERE `Matrix_Unique_ID` = '206551302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '4106171' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Fidel Tamez' ,`SellingOfficeName` = 'Torres Real Estate Group' ,`Latitude` = '30.166586' ,`Longitude` = '-95.286952' ,`PhotoCount` = '13' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '303940.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Portbec' ,`StreetNumber` = '18502' ,`StreetSuffix` = 'Court' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INCREDIBLE NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! Premium Corner Cul-de-Sac Lot! Open Concept Interior Design! Great Island Kitchen with Stainless Appliances, 36\" Flat Panel Maple Cabinetry, Exotic Granite, & Corner Walk-In Pantry! Supersized Family Room & Spacious Dining Area! Privately Located Primary Suite with Garden Bath & Walk-In Closet! Includes Refrigerator!! Blinds and Garage Door Opener! Smart Home System, Full Sprinkler System, Full Front Landscape, Tankless Water Heater, Front & Back Sod, LED Lighting, PLUS MORE!' ,`Acres` = '0.2436' ,`Area` = '40' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S812705 - PORTERS MILL 05, BLOCK 1, LOT 70' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'NEW CANEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Porters Mill' ,`TaxAmount` = '193' ,`TaxRate` = '3.0331' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698271' WHERE `Matrix_Unique_ID` = '207581515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '38615742' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Leonardo Perez Rodriguez' ,`SellingOfficeName` = 'NEXTHOME Premier Homes Realty' ,`Latitude` = '30.235754' ,`Longitude` = '-95.707862' ,`PhotoCount` = '12' ,`PostalCode` = '77354' ,`RoomCount` = '3' ,`ListPrice` = '303490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'BLACKBRUSH MANOR' ,`StreetNumber` = '14718' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming brand NEW Express Home in the best location! Lovely curb appeal with landscape package! Wonderful open floor plan with designer details and modern finishes! Great island kitchen with granite countertops! Perfect bedroom one suite with spa like bath and spacious closet! Also features a useful covered back patio! Mill Creek is in a great area and is zoned to Magnolia ISD! Hurry and call today!' ,`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` = 'Lot 19 Block 2 Section 2' ,`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`='1663698271' WHERE `Matrix_Unique_ID` = '207777401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '37841220' ,`ListAgentFullName` = 'Carla Wade' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.206803' ,`Longitude` = '-94.954322' ,`PhotoCount` = '44' ,`PostalCode` = '77554' ,`RoomCount` = '5' ,`ListPrice` = '514999.00' ,`Status` = 'Active' ,`StreetName` = 'Cade' ,`StreetNumber` = '14539' ,`StreetSuffix` = 'Lane' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The views from this beautiful home are stunning! The home has the feel of its historic Galveston roots, but with all of the beauty and comfort that you want today. The home also has a vast oversized garage that will accommodate your boat and golf cart in addition to your cars! The kitchen features quartz counters, glass tile backsplash, recessed spot lighting, stainless appliances including a gas cooktop and white cabinetry. The breakfast bar serves 6 people and is open to the living and dining area. The French doors open from the family room to the beautiful first floor balcony with incredible views of West Bay, Lake Como and the State Park. The primary and secondary bedrooms are on the second floor and both have ensuite baths. The primary has a private balcony with gorgeous views, soaring ceilings with a cupola feature for added beauty. The home is sold fully furnished with its pretty coastal decor. It is an active and successful vacation rental.' ,`Acres` = '0.0655' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAYSIDE AT WATERMAN\'S FISH CAMP (2017) ABST 121, BLOCK 9, LO' ,`LotDesciption` = 'Water View' ,`LotSize` = '2853' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Minor Plat/Fish Camp/Waterman' ,`TaxAmount` = '4494' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698271' WHERE `Matrix_Unique_ID` = '207830508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '65342290' ,`ListAgentFullName` = 'Rickey Chavez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.891430' ,`Longitude` = '-95.698952' ,`PhotoCount` = '27' ,`PostalCode` = '77433' ,`RoomCount` = '3' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Feather Lance' ,`StreetNumber` = '19107' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1878' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this open concept floorplan nestled in Yaupon Ranch. Three bedroom two and half bath home is full of potential and move in ready. HVAC system has been replaced in 2020 and gorgeous laminate and tile flooring throughout the downstairs. Spacious front and backyard with manicured landscaping perfect for weekend BBQ\'s and entertaining family and friends. Ready to find your forever home? Schedule an appointment today.' ,`Acres` = '0.1587' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 BLK 3 YAUPON RANCH SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6915' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Ranch Sec 7' ,`TaxAmount` = '5819' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698271' WHERE `Matrix_Unique_ID` = '207863211' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '89908298' ,`ListAgentFullName` = 'Stephen Hallmark' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.400925' ,`Longitude` = '-95.667694' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '20' ,`ListPrice` = '1799000.00' ,`Status` = 'Active' ,`StreetName` = 'Harbor Side' ,`StreetNumber` = '18980' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Montgomery' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '8192' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury living in Harbor Side. Features of the home and property include: 5/6 bedrooms, 2 laundry rooms (first and second floor). 2 bedrooms down (master and secondary with ensuite bath). All bedrooms have ensuite baths. There is a Media room, Game room. 4 boat slips, 3 covered boat slips, pier, and access to lake, Infinity salt water pool, out dooor kitchen (grill, burner, refrigerator, granite counter tops, ice maker, dishwasher). Interior amenities include: 3 stair cases, double oven, gas appliances, pantry as large as a bedroom, master bedroom with firepleace, ensutie study with wood accents, work out room, craft/extra room, pool bathroom. Property is over an acre of land, gated neighborhood entry, 4 car garage. Call for more details before home is one the market....' ,`Acres` = '1.422' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HARBOR SIDE 02, BLOCK 1, LOT 9' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '61942' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbor Side 02' ,`TaxAmount` = '21609' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Sewer,Public Water,Septic Tank,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698272' WHERE `Matrix_Unique_ID` = '207889652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '56709090' ,`ListAgentFullName` = 'Adria Czerewaty' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.758616' ,`Longitude` = '-95.471637' ,`PhotoCount` = '50' ,`PostalCode` = '77056' ,`RoomCount` = '14' ,`ListPrice` = '2899000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar Hill' ,`StreetNumber` = '5443' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '8396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This regal Tanglewood residence built by A. Taghi Homes is the ideal destination for lavish entertaining and refined daily living with exquisite interiors and outstanding outdoor space. Hardwood floors, archways, soaring ceilings and designer details throughout. The double-height foyer introduces stunning formal living and dining rooms surrounded by a walk-up bar and wine room. A spectacular gourmet kitchen leads to breakfast room and family room. Outside, enjoy al fresco gatherings on the beautiful, covered veranda with built-in grill, fireplace and ceiling fans. The pool and spa invite you to cool off on hot days surrounded by lush tropical landscaping. Main-floor owner\'s suite offers two enviable walk-in closets and spa bathroom. Above, secondary beds and baths are joined by a charming mezzanine sitting area and a game room with a kitchenette. Circular drive, gated porte-cochère, 4-car garage. Zoned HVAC, central vacuum. Close to Galleria, Memorial Park and Houston Country Club.' ,`Acres` = '0.3542' ,`Area` = '22' ,`BuilderName` = 'A. Taghi Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 10 TANGLEWOOD SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood' ,`TaxAmount` = '66547' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698272' WHERE `Matrix_Unique_ID` = '208746708' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '73423941' ,`ListAgentFullName` = 'Janet Bass' ,`ListOfficeName` = 'Leopold & Strahan Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.288760' ,`Longitude` = '-94.826430' ,`PhotoCount` = '11' ,`PostalCode` = '77551' ,`RoomCount` = '5' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue L' ,`StreetNumber` = '5325' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy recently updated home. This home has been well maintained and taken care with a bonus of an extremely large, fenced yard for you to enjoy. The home has fresh new paint, new flooring, updated electrical, central air conditioning and heat along with a new hot water heater. This home is a wonderful starter home for first time buyer, a great investment property for investors, or even a vacation rental property for those wanting to have a home away from home. The property has abundance of yard space for you to develop your own style and living space for outdoor area living or even the possibility of another living space for you to enjoy.\r\nNOTE: All sq ft are aproximate and all room measurements are aproximate, home looks larger on the inside than it apprears on the outside.' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOTS 3 & 4 BLK 28 DENVER RESURVEY' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`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,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Denver Resurvey' ,`TaxAmount` = '1777' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698272' WHERE `Matrix_Unique_ID` = '208913654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '27891926' ,`ListAgentFullName` = 'Travis Edmunds' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.269693' ,`Longitude` = '-95.469543' ,`PhotoCount` = '48' ,`PostalCode` = '77304' ,`RoomCount` = '13' ,`ListPrice` = '579857.00' ,`Status` = 'Active' ,`StreetName` = 'Coleto Run' ,`StreetNumber` = '831' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes New Construction -Your NEW certified energy-efficient Ellicott plan with 2 bedroom suites down has great curb appeal & boasts top-notch design features you won\'t find with the other builders. Enter this showpiece home through the beautiful 8ft entry door & you\'ll immediately be \"wowed\"! Soaring wrought iron curved staircase with stunning tiered rotunda! upgraded 24x8in tile flooring, 8ft Doors & large 7in base trim which add to the custom home feel. Your dream open kitchen has Whirlpool stainless steel appliances, Valley White quarts countertops, quality Kentmoore cabinetry & a Texas-size island open to the living room. Upstairs includes a game room, private surround sound-wired media room, two additional bedrooms, and a Hollywood Bath. Fully sodded yard with sprinkler system and covered patio. Located in the most convenient location of Grand Central Park between The Woodlands & Lake Conroe.' ,`Acres` = '0.14' ,`Area` = '19' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Grand Central Park Lot:7 /Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6101' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1073' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '' ,`TaxRate` = '3' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698272' WHERE `Matrix_Unique_ID` = '209008754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '69156961' ,`ListAgentFullName` = 'Priyan Jacob' ,`ListOfficeName` = 'Stride Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.554900' ,`Longitude` = '-95.527332' ,`PhotoCount` = '48' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Crescent Oak Drive' ,`StreetNumber` = '1919' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CRESCENT OAK VILLAGE AT LAKE OLYMPIA SEC' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698272' WHERE `Matrix_Unique_ID` = '209014185' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '54970363' ,`ListAgentFullName` = 'Scarlett Snell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.376007' ,`Longitude` = '-95.617465' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Capetown' ,`StreetNumber` = '100' ,`StreetSuffix` = 'Circle' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lake living at it\'s best!! Come see this stunning lake view property. Situated on a LARGE corner lot this home has it all. Exterior you\'ll love the double wide driveway which provides plenty of space to park. No neighbors on either side of the property line. Awesome covered porch with beautiful landscape lighting that creates a stunning serene environment for relaxing in the evenings. Through the gorgeous wood and glass front door you\'ll be greeted in the formal entry with rich flooring, recessed lighting, oversized craftsman baseboards and trim, along with crown molding setting the tone for the beauty in this home. Continue into the living room where all these stunning features flow. Enjoy evenings listening to the crackle of the fireplace and the view out of the wall of picture windows. You\'ll be pleased with the abundance of space in the kitchen and the natural light that flows throughout the home. To complete the dream lake life enjoy the MANY top notch amenities! Come see it now!' ,`Acres` = '0.1232' ,`Area` = '39' ,`BuilderName` = 'Cooper Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S215007 - APRIL SOUND 07, BLOCK 70, LOT 3, 4' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot,Water View' ,`LotSize` = '5368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '234' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'April Sound 07' ,`TaxAmount` = '6678' ,`TaxRate` = '2.2625' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698272' WHERE `Matrix_Unique_ID` = '209025449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '42548191' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Karyn Edwards' ,`SellingOfficeName` = 'Crestway Properties, LLC' ,`Latitude` = '30.180804' ,`Longitude` = '-95.150673' ,`PhotoCount` = '11' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '338240.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Colosseum' ,`StreetNumber` = '2326' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Over 20,000 square foot wooded lot that backs to greenspace and 3 car garage! This 4 bedroom, 2 bath property has an amazing use of natural light. The open kitchen features shaker cabinets, granite countertops and stainless-steel appliances! The spacious Primary Suite is tucked away for your own private retreat with separate shower and garden tub. The home has front sprinklers, and a home automation system. You will appreciate the great storage and energy efficient features throughout. Hurry and call today!!!' ,`Acres` = '0.461' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S839704 - ROMAN FOREST 04, BLOCK 9, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20081' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates At Roman Forest 04' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698272' WHERE `Matrix_Unique_ID` = '209084864' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '91524201' ,`ListAgentFullName` = 'Kayla Scarbrough' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.404629' ,`Longitude` = '-94.926816' ,`PhotoCount` = '10' ,`PostalCode` = '77590' ,`RoomCount` = '8' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = '21st' ,`StreetNumber` = '2206' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1818' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 167 D RICHARDSON SUR LOT 8 BLK 7 CLEARVIEW TERRACE SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'GUAJARDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clearview Terrace' ,`TaxAmount` = '4336' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663698273' WHERE `Matrix_Unique_ID` = '209209752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '13598515' ,`ListAgentFullName` = 'Jennifer Delaney' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.294921' ,`Longitude` = '-94.801419' ,`PhotoCount` = '7' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = '32nd' ,`StreetNumber` = '1224' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1259' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Starting at 550,000.00 NEW Construction.This open concept 3/2 boasts almost 1300 sq. ft. Built on raised pilings in a preferred flood zone, the exceptional construction of this home is engineered to exceed windstorm building codes, Designed by Plum Construction, the open concept living flows into a custom designed kitchen showcased with built in storage, marble surfaces, designer finishes as well as vintage inspired appliances.The first floor primary bedroom offers it\'s own private terrace and oversized closets. Two spacious bedrooms on the second floor allow for ample space to entertain friends and family. Fully furnished with curated pieces and attention to detail, this home is a true work of art! Centrally located, blocks from The Strand and the Seawall making it the perfect second home/ investment property.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Delaneys Restoration' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 7 (1007-0) BLK 31 RPLT GALVESTON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2551' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663698273' WHERE `Matrix_Unique_ID` = '209543574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '96619416' ,`ListAgentFullName` = 'Norma Smalley' ,`ListOfficeName` = 'Cobb Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.452852' ,`Longitude` = '-94.632368' ,`PhotoCount` = '50' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '874000.00' ,`Status` = 'Active' ,`StreetName` = 'Kahla' ,`StreetNumber` = '829' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom, 2 1/2 bath home has so much to offer, including beach views. This is an entertainer\'s dream home! The Mezzanine level is perfect for large functions, parties, and all types of entertaining. This is a MUST SEE home! From the standing seam metal roof, to the vaulted ceiling, and the wood floors, this is a very unique home. These are the unique features: kitchen area in the mezzanine level, 2 entrances in the home, large laundry room, lots of storage room, 10 ft ceilings in the bedrooms, wall mounted lamps on either side of the master bed, heaters in both full bath rooms, vaulted ceiling in the family room, just an exceptional home. Please verify all room dimensions. No survey; buyer to purchase new one.' ,`Acres` = '0.124' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 57 BLK B GULF VIEW' ,`LotDesciption` = 'Water View' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gulf View 1' ,`TaxAmount` = '6593' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698273' WHERE `Matrix_Unique_ID` = '209580033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '44447788' ,`ListAgentFullName` = 'Fernando Mendoza' ,`ListOfficeName` = 'Veronica Mendoza Realty, LLC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724559' ,`Longitude` = '-95.928793' ,`PhotoCount` = '23' ,`PostalCode` = '77423' ,`RoomCount` = '7' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Tourmaline way' ,`StreetNumber` = '5403' ,`StreetSuffix` = '' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Can arguably be the biggest lot in the neighborhood. This incredible 1 Story 3-bedroom 2-bath 2-car garage home features a Handsome Study with French Doors for the study, Massive Island Kitchen w/ 36\" Designer Cabinets, and Quartz Countertops. The kitchen opens to a Casual Dining Room and a spacious family room! Primary Bedroom has an En Suite Bathroom with Shower and Two Walk-in Closets! Resilient Luxury Vinyl Plank Floors; Covered Patio to enjoy the biggest backyard you can have!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0003 BLK 005 LOT 025' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '14275' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698273' WHERE `Matrix_Unique_ID` = '209603074' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '6889035' ,`ListAgentFullName` = 'Tabata Cooke' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.716604' ,`Longitude` = '-95.523232' ,`PhotoCount` = '26' ,`PostalCode` = '77036' ,`RoomCount` = '7' ,`ListPrice` = '383000.00' ,`Status` = 'Active' ,`StreetName` = 'Prestwood' ,`StreetNumber` = '7819' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BIG BACK YARD AND PRISTINE INTERIOR in Sharpstown Country Club Estates with Privacy Driveway Gate. This well maintained home features 3 bedrooms, 2 full baths, and a great covered patio area with plenty of ventilation. There are many aspects that make this home special: Upgraded Italian Ceramic Floors, Costume Made Cabinets, Book Shelves and Bar, remodeled bathrooms, Stainless Steel appliances and Granite in the kitchen, 1.5 L Generac generator (You will never run out of Power!), recently replaced \"high quality\" Roof, Water Softener, Alarm and a 6-Camera Security System that you can track from your own phone, Mosquito Misting System to be able to enjoy the Backyard, Sprinkler System in front and back, and Recently installed Sewerage. The list is long, Come See It Yourself. Schedule your Showing today! Independently verify Room Dimensions. If you need to contact agent use WhatsApp please.' ,`Acres` = '0.2938' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 9B & 10B BLK 15 SHARPSTOWN COUNTRY CL EST 3 RP' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12798' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'EMERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Country Cl Estate 0' ,`TaxAmount` = '5035' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698273' WHERE `Matrix_Unique_ID` = '209662189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '59936973' ,`ListAgentFullName` = 'Hung Nguyen' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586002' ,`Longitude` = '-95.667099' ,`PhotoCount` = '28' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '579900.00' ,`Status` = 'Active' ,`StreetName` = 'Emma Cove' ,`StreetNumber` = '1738' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite updated 4 bedroom lakeview home located in the prestige New Territory subdivision of Sugar Land. The formal entryway feature an immaculate foyer showcasing high ceilings and elegant chandeliers. The spacious living area has large windows that allow you to look onto gorgeous lakeview backyard. An open-concept kitchen with beautiful Quartz countertops has abundance of counter space and cabinetry. The executive primary bedroom showcases the view of the lake through its large glass windows and spacious bathroom featuring separated shower and tub. Additional room down can be use as home office. Huge game room up great for entertaining. Zoned to Sugar Land top rated schools. Schedule your appointment today. Won\'t last.' ,`Acres` = '0.1891' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NEW TERRITORY PARCEL SF-20A, BLOCK 3, LOT 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8239' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'WALKER STATION ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'New Territory Prcl Sf-20a' ,`TaxAmount` = '9758' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698273' WHERE `Matrix_Unique_ID` = '209669313' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '62356994' ,`ListAgentFullName` = 'Gleshia Givens' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.470792' ,`Longitude` = '-95.510311' ,`PhotoCount` = '32' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '705000.00' ,`Status` = 'Active' ,`StreetName` = 'Camille Park Drive' ,`StreetNumber` = '1914' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Luxury Living in the well acclaimed community of Sienna. This meticulous new one story Toll Brothers home definitley makes a statement. Opening the doors, the foyer greets you in grand style with beautiful hardwood floors throughout the main area, soaring 12 ft tray ceilings with elegant light fixtures that all have been upgraded. You will immediately fall in love with the open concept layout, family room and kitchen that boast a large gourmet island, Smart and chef style high end appliances, Reverse Osmosis water filtration,custom cabinets/walk in butlers pantry. Secondary bedrooms each have their own en-suites & walk-in closets. The secluded primary retreat features tray ceilings, dual vanity, free standing soaking tub, over size shower along with his/her walk in closet. The office has french doors with built ins that makes it convenient to work from home in comfort/enjoy the surround sound in the media room. Highly rated FBISD schools and resort style amenities' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Block 1 Lot 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8439' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1229' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sienna Collection' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698273' WHERE `Matrix_Unique_ID` = '210108974' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '57843132' ,`ListAgentFullName` = 'Elena Tsilina' ,`ListOfficeName` = 'House Hunter Houston, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.593026' ,`Longitude` = '-95.230809' ,`PhotoCount` = '49' ,`PostalCode` = '77089' ,`RoomCount` = '5' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Sagevale' ,`StreetNumber` = '10811' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1514' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one-story 3-bedroom/ 2-bathroom house in the popular established neighborhood of Sagemont. As you walk in the door to your right you will find a spacious flex room perfect for a formal dining room, home office, gym, game room, or 2nd living room. This home also features recent AC and water heater units, tile flooring, a shed, and a large backyard. Washer/dryer, refrigerator – all negotiable! Call today to schedule your private showing!' ,`Acres` = '0.1667' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 BLK 53 SAGEMONT SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FRAZIER ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sagemont Sec 09' ,`TaxAmount` = '4215' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698274' WHERE `Matrix_Unique_ID` = '210417440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '37036112' ,`ListAgentFullName` = 'Victorino Cortez' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.983281' ,`Longitude` = '-95.141680' ,`PhotoCount` = '33' ,`PostalCode` = '77044' ,`RoomCount` = '4' ,`ListPrice` = '359500.00' ,`Status` = 'Active' ,`StreetName` = 'Alcantara River' ,`StreetNumber` = '18218' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2469' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4-bedroom, 3-bathroom home located in Bridges on Lake Houston. This property offers nearly 2500 square feet of living space and a in-law suite inclusive of a full bathroom. Your family and loved ones will enjoy the spacious backyard, perfect for family gatherings. Home includes irrigation system, stainless steel appliances, and smart home technology. There is plenty of shopping and dining nearby. Must see!' ,`Acres` = '0.1992' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 2 BRIDGES ON LAKE HOUSTON SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8679' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridges/Lk Houston Sec 7' ,`TaxAmount` = '8529' ,`TaxRate` = '3.303' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698274' WHERE `Matrix_Unique_ID` = '210510982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '51932426' ,`ListAgentFullName` = 'Alexandra Marquez' ,`ListOfficeName` = 'Zarco Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.325142' ,`Longitude` = '-95.507077' ,`PhotoCount` = '48' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Fork' ,`StreetNumber` = '4783' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3278' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one checks all the boxes! Come live a great lifestyle in this brand new, custom home on a huge lot in this wonderful Golf Course Community. Home features 1.5 stories, 4 bedrooms, 4.5 baths, high ceilings, lots of natural light, huge gameroom upstairs w/full bath, plus study, covered back pork, summer kitchen with granite countertop & a full 3 Car Garage with Epoxy flooring. Stucco & brick exterior, wood tile all throughout, large open island kitchen with quartz countertop, SS appliances & tons of storage. All bathrooms have large showers, granite countertops & electric mirrors. Easy access to I-45.' ,`Acres` = '0.3792' ,`Area` = '19' ,`BuilderName` = 'Stonewood Landmark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S949103 - WEST FORK 03, BLOCK 7, LOT 46, ACRES 0.3792' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '16518' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'West Fork 03' ,`TaxAmount` = '1030' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698274' WHERE `Matrix_Unique_ID` = '210591690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '80466669' ,`ListAgentFullName` = 'Marcelo Zubieta' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062177' ,`Longitude` = '-95.428710' ,`PhotoCount` = '38' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypresswood Hill' ,`StreetNumber` = '534' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Beautiful, spacious, corner lot home in quiet gated community like this one is hard to find in the Houston area. Schedule your showing today, this listing will not last long. Excellent location with quick access to 99 Grand Parkway, I45, Intercontinental airport, Dining, schools, and shopping. Covered patio and large backyard provide plenty of space for activities and relaxation. Includes outdoor shed and built-in outdoor sink. Refrigerator in the house conveys with the sale. HVAC replaced 2019 and tankless water heater installed 2021. Although deemed to be correct, please verify square footage, room sizes, and school information. Community offers nice outdoor pool, beach voleyball court, and walking/running path around the lake.' ,`Acres` = '0.1128' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 CYPRESSWOOD LAKE SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '4915' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '733' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GINGER MCNABB ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Lake Sec 03' ,`TaxAmount` = '4888' ,`TaxRate` = '2.4967' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698274' WHERE `Matrix_Unique_ID` = '210658171' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '62076775' ,`ListAgentFullName` = 'Michael Buffington' ,`ListOfficeName` = 'Triangle Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.214022' ,`Longitude` = '-94.261844' ,`PhotoCount` = '33' ,`PostalCode` = '77625' ,`RoomCount` = '6' ,`ListPrice` = '980000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 421' ,`StreetNumber` = '4945' ,`StreetSuffix` = 'Road' ,`City` = 'Kountze' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3168' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Own your very own slice of paradise. Located in HJ ISD, on over 35 acres of land & a pond, this home has it all! Walk in to be greeted w/ high ceilings, beautiful concrete floors & and open floorplan. The living room boasts a beautiful fireplace & a wall full of picture windows overlooking the outdoors. In the kitchen you\'ll find gorgeous one of a kind granite countertops, stainless steel appliances, pot filler & large island. If you like to entertain guests, this is the place for you! Retreat to the master suite where you\'ll find granite countertops, double sinks, a beautiful shower/tub combo, along w/ your very own private balcony. Outside you have a large patio, in-ground pool for all the hot summer days AND guest house, fully equipped w/ a kitchen, bathroom, laundry, living area & bedroom. This home has it all & then some, & don\'t forget the whole-house generator and a safe room! You HAVE to see it for yourself there is too much to list! Call today to schedule your personal tour!' ,`Acres` = '35' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'AB 54 I VILLEGAS P# 54-34-B-1 I# 1570/403' ,`LotDesciption` = 'Cleared,Water View,Wooded' ,`LotSize` = '631620' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Barndominium,Ranch,Traditional' ,`Subdivision` = 'OTHER' ,`TaxAmount` = '47' ,`TaxRate` = '1.8375' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663698274' WHERE `Matrix_Unique_ID` = '210668064' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '21196503' ,`ListAgentFullName` = 'Tiffany Curry' ,`ListOfficeName` = 'BHHS Tiffany Curry & Co., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560437' ,`Longitude` = '-95.436083' ,`PhotoCount` = '43' ,`PostalCode` = '77584' ,`RoomCount` = '16' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenblade' ,`StreetNumber` = '2712' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4547' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS 2-STORY PERRY HOME w/5 bedroom/3.5 bath/3-car on a great lot in Shadow Creek Ranch. RARE ONE-OF-A-KIND home is the only home w/ this floorplan in the community! Great NEXT-GEN home features 2-PRIMARY BEDROOMS & 2-OFFICES! 1st Primary suite downstairs w/a large walk-in-closet & oversized primary\'s bath. Formal Dining, Butler\'s Pantry, Study, Family Room w/fireplace; granite island kitchen, extended covered patio & Breakfast area. Upstairs your entertaining begins w/an enormous Game Room perfect for reading/crafting/hanging out or watching tv. Upstairs also features a 2nd Study, 4 bedrooms w/spacious closets & an extra large storage closet. Huge backyard w/tons of space for a pool & playground perfect for pets, kids & gardening! Community features Splash Pads, Pools, Basketball, Tennis, Soccer, Walking Trails, Lakes, Clubhouse & more! Minutes to HWY 288, New Toll, Pearland Town Center, Grocery Stores, Restaurants, Medical Center, Downtown Houston & more! NEVER FLOODED!!!' ,`Acres` = '0.2182' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-53, BLOCK 2, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch' ,`TaxAmount` = '13110' ,`TaxRate` = '3.2123' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698274' WHERE `Matrix_Unique_ID` = '210797953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '18251284' ,`ListAgentFullName` = 'Kathryn Klimczak' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699771' ,`Longitude` = '-95.103325' ,`PhotoCount` = '34' ,`PostalCode` = '77536' ,`RoomCount` = '8' ,`ListPrice` = '409000.00' ,`Status` = 'Active' ,`StreetName` = 'Wynchase' ,`StreetNumber` = '1905' ,`StreetSuffix` = 'Drive' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classic 4/2.5/2 brick home in desired Wynfield Estates with porte cochere, POOL AND SPA! Features include engineered wood flooring, soaring ceilings, large upstairs game room and 4 generous bedrooms. The kitchen has Corian counter tops, stainless appliances, cook top island, pantry, breakfast bar.... The breakfast room opens to the primary living space with a beautiful fireplace serving as the focal point. An abundance of large windows and high ceilings give this space plenty of natural light. Upstairs, the game room comfortably fits a pool table, shuffleboard table and more! Pool table, shuffleboard table and piano may be negotiated with purchase. Outside you\'ll find an outdoor oasis with sparkling swimming pool and hot tub with NO BACK NEIGHBORS!' ,`Acres` = '0.1758' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 WYNFIELD ESTATES SEC 3A' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7657' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wynfield Estates Sec 03a' ,`TaxAmount` = '8302' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698274' WHERE `Matrix_Unique_ID` = '210802690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '34974296' ,`ListAgentFullName` = 'Jamil Joyner' ,`ListOfficeName` = 'Signature Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665910' ,`Longitude` = '-95.444387' ,`PhotoCount` = '28' ,`PostalCode` = '77025' ,`RoomCount` = '8' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Bassoon' ,`StreetNumber` = '10618' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new construction 4 bedroom/2.5 bathroom located in the heart of Houston near the Medical Center and minutes to the Galleria. The home was meticulously built by Grace Building Company with open spaces and plenty of light. The master suite is downstairs and features a soaking tub plus a stand alone shower. The floors are a warm engineered hardwood throughout. The playroom upstairs is spacious and overlooks the first floor. Enjoy double sinks in the upstairs bathroom and a formal dining room on the first floor. This home is not located in a flood zone.' ,`Acres` = '0.1641' ,`Area` = '20' ,`BuilderName` = 'Grace Building Co.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 1 WESTWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Sec 01' ,`TaxAmount` = '3000' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698275' WHERE `Matrix_Unique_ID` = '210889638' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '77531110' ,`ListAgentFullName` = 'Vuong-Vu Bui' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541493' ,`Longitude` = '-95.608329' ,`PhotoCount` = '48' ,`PostalCode` = '77479' ,`RoomCount` = '13' ,`ListPrice` = '1688888.00' ,`Status` = 'Active' ,`StreetName` = 'Rouchel Brook' ,`StreetNumber` = '5426' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '5510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy luxury living at its finest in this gorgeous Mediterranean villa, located in the gated section of the award-winning Avalon at Riverstone community. This lakeview home truly elevates your everyday living, boasting stunning curb appeal, a thoughtfully designed floorplan w/ the most exquisite interior & exterior features. As you enter the private gateway into the gorgeous courtyard, prepare to be wowed at every turn. This home is grand in every sense of the word yet still feels warm and cozy. Grand foyer, double staircases, soaring ceilings w/ an abundance of natural light, chef’s dream kitchen, plenty of room to spread around w/ 3 beds on each floor plus a formal dining, breakfast area, study, sitting area, game room & media room with a custom bar. Whole house surround sound system keeps music playing and you singing and dancing. Extend your living outside w/ an extended covered patio, paved-in yard, outdoor kitchen and a saltwater pool & spa. Come, experience, & make it yours!' ,`Acres` = '0.2506' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON AT RIVERSTONE SEC 15-B PHASE II, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '10914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1810' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Avalon At Riverstone' ,`TaxAmount` = '19167' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698275' WHERE `Matrix_Unique_ID` = '210979867' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T01:22:01.200' ,`MLSNumber` = '45756876' ,`ListAgentFullName` = 'Bridget Moore' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.308532' ,`Longitude` = '-95.747969' ,`PhotoCount` = '31' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Crawford' ,`StreetNumber` = '10922' ,`StreetSuffix` = 'Circle' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one has it all! Beautiful 2 story, 4 bed, 2.5 bath home with a 3 car garage! Situated on almost an ACRE, cul-de-sac lot and zoned to Montgomery ISD with a GENERATOR! Located in the desirable Stone Ranch subdivision surrounded by mature trees, offering the finest in privacy! Updated and shows like a model! Formal dining is open to kitchen and features custom accent wall. Granite kitchen features stainless appliances, breakfast bar and is open to dining, breakfast and den. Den offers a gorgeous fire place, high ceilings and plenty of space! Spacious primary bedroom located downstairs with custom accent wall, bay window and room for oversized furniture. Primary bath has dual sinks, vanity, separate shower, garden tub and WALK IN CLOSET! Upstairs you will find 3 bedrooms and a huge game room - ample space for entertaining and perfect for all! Stone Ranch offers 30 acres of equestrian trails, easy access to 1488 & 105! DON\'T WAIT!' ,`Acres` = '0.99' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S903103 - STONE RANCH 03, BLOCK 2, LOT 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '43124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Ranch 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698275' WHERE `Matrix_Unique_ID` = '211055616' --> Updated record success