Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T16:56:21.340' ,`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` = '1695000.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 Lucian Hood designed 5 bedroom brick home situated on a large 16,012sf lot in Broad Oaks. The first floor was built for entertaining! The inviting reception hall opens to the spacious, light-filled living room with windows on three sides & a gas log fireplace & 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 & tons of counter & cabinet space. It opens to the cozy family room with a fireplace & to the breakfast area. Upstairs spacious main bedroom with vaulted ceilings, fireplace, en-suite bathroom & 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 & 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`='1675347683' WHERE `Matrix_Unique_ID` = '204319067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T16:03:23.447' ,`MLSNumber` = '64166893' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398504' ,`Longitude` = '-95.499532' ,`PhotoCount` = '30' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Calm Savanna' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perry Homes New Construction! Entry and extended entry with 13-foot ceiling. Home office with French doors. Game room with French doors. Kitchen features a large pantry and a large island that has a built-in seating space, 5-burner gas cooktop and a double wall oven. Open dining area with a wall of windows. Open family room with a cast stone fireplace and a wall of windows. Private primary suite with a wall of windows. Double doors lead to primary bath with separate vanities, garden tub, separate glass enclosed shower and two walk-in closets. Extended covered backyard patio. Mud room leads to 3-car garage.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S927100 - The Woodlands Hills 01, BLOCK 1, Lot 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12730' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347684' WHERE `Matrix_Unique_ID` = '205085920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T16:02:55.883' ,`MLSNumber` = '16345081' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398504' ,`Longitude` = '-95.499532' ,`PhotoCount` = '31' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '679900.00' ,`Status` = 'Active' ,`StreetName` = 'Calm Savanna' ,`StreetNumber` = '219' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perry Homes New Construction! French door entry with 13-foot ceiling framed by home office with French doors. Formal dining room just off the extended entry. Island kitchen with walk-in pantry, a 5-burner gas cooktop and a double wall oven. Spacious family room with wall of windows, wood mantel fireplace and 12-foot ceiling. Morning area adjacent to game room with wall of windows. Secluded primary suite with 11-foot ceiling and a wall of windows. French door entry to the primary bath with dual vanities, a garden tub, separate glass enclosed shower and two walk-in closets. Secluded guest suite with a full bathroom and walk-in closet. Extended covered backyard patio. Mud room just off the three-car garage.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S927100 - The Woodlands Hills 01, BLOCK 1, Lot 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11756' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347685' WHERE `Matrix_Unique_ID` = '205086111' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T16:38:21.400' ,`MLSNumber` = '5065203' ,`ListAgentFullName` = 'Marnie Greenwood' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726822' ,`Longitude` = '-95.397768' ,`PhotoCount` = '34' ,`PostalCode` = '77006' ,`RoomCount` = '15' ,`ListPrice` = '4500000.00' ,`Status` = 'Active' ,`StreetName` = 'South' ,`StreetNumber` = '1412' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live on one of Houston\'s most sought after streets: South Boulevard! The oak-lined ave will lead you to this historic home, which sits on an exceptional 38,295 SF corner lot. The charming brick colonial offers comfortable and functional living. The first floor showcases large formal living room surrounding marble fireplace, bright library with built-in bookshelves and fireplace, a designated formal dining room, island kitchen and a sunroom. The second floor includes a large primary suite and two additional bedrooms. Remarkable wrap-around porch on second floor makes outdoor/indoor living easy. Additional open concept pool house/game room located behind the home with one bedroom apartment complete with kitchenette and full bath on second floor. A pool house terrace overlooks the pool and yard. Large circle drive at the front of the home with additional parking in rear. Located in the historically preserved subdivision of Broadacres.' ,`Acres` = '0.8791' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BROADACRES' ,`LotDesciption` = 'Corner' ,`LotSize` = '38295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Broadacres' ,`TaxAmount` = '95557' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347686' WHERE `Matrix_Unique_ID` = '206213428' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T16:08:35.563' ,`MLSNumber` = '39342796' ,`ListAgentFullName` = 'Donna Mazzola' ,`ListOfficeName` = 'Etheredge Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.354382' ,`Longitude` = '-94.990717' ,`PhotoCount` = '12' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Lower Borondo' ,`StreetNumber` = '141' ,`StreetSuffix` = '' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand New Construction. This 2038 Sq Ft home lives larger than it looks from outside! High ceilings in main rooms. Open concept. Features a Beautiful Granite Island Kitchen equipped w/ all Samsung appliances, soft close cabinets & drawers and large walk-in pantry. Very Spacious Living/Dining rooms. The Primary Suite boasts a beautiful over-sized 6\' X 4\' custom tile walk-in shower & double sinks. Plenty of closet space for Two. 2 more bedrooms are also good sized. All rooms have ceiling fans w/lights. The guest bath has custom tile around tub w/ shower. All Flooring is 50 yr wnty, water resistant Rubber Laminate w/wood look. Full size utility/laundry room. Gas stove, water heater, furnace & dryer connection-money saver! 4 Ton 16 Seer Goodman HVAC. Covered Patio in back 10\' X 16\' & a nice 5\' X 20\' porch on front entrance w/ extra wide driveway on the side leading to a 2 car garage. Roofing is 30Yr Architectural. Durable Hardie Siding. Built entirely with Treated Lumber' ,`Acres` = '0.1936' ,`Area` = '33' ,`BuilderName` = 'CompleteConstruction' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 2 S F AUSTIN SUR LOT 9 BLK 1 BORONDO PINES SUB (2002)' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8434' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '319' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'WESTLAWN ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Craftsman,Ranch,Traditional' ,`Subdivision` = 'Borondo Pines 2002' ,`TaxAmount` = '451' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347687' WHERE `Matrix_Unique_ID` = '206620594' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T15:11:15.767' ,`MLSNumber` = '88696434' ,`ListAgentFullName` = 'Alicia Reader' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.306724' ,`Longitude` = '-95.500760' ,`PhotoCount` = '17' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Falling Pine' ,`StreetNumber` = '308' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2835' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two story home with inviting front porch and fantastic open layout. You will never miss out on the action from the spacious kitchen overlooking the dining and living rooms! Neutral colors with wood look and tile floors will allow you to make this home your own. Spend time outdoors in this spacious and welcoming backyard. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.1263' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S799100 - PINEWOOD FOREST, BLOCK 1, LOT 120, ACRES 0.126' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '351' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinewood Forest' ,`TaxAmount` = '4774' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347688' WHERE `Matrix_Unique_ID` = '207117332' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T16:29:24.790' ,`MLSNumber` = '13192997' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Development Management' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795660' ,`Longitude` = '-95.850270' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '700900.00' ,`Status` = 'Active' ,`StreetName` = 'Pemberley' ,`StreetNumber` = '7519' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Two story entry with 196-foot ceilings. Home office with French doors just off the Foyer with an adjacent circular staircase. Two story family room with a grand wall of windows and corner cast stone fireplace extends to the dining area. Island kitchen with built-in seating space, 5-burner gas cooktop and a corner walk-in pantry. Secluded primary suite features bedroom with 12-foot ceilings, double door entry to primary bathroom, dual vanities, center garden tub, separate glass enclosed shower, two walk-in closets and additional private entry to the utility room. Guest suite with full bathroom and a walk-in closet on first floor. Second floor hosts a generous game room that overlooks the family room and dining area, media room, a Hollywood bathroom and secondary bedrooms. Covered backyard patio. Three-car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Cane Island Lot 33, Blk 1, Section 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7942' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347689' WHERE `Matrix_Unique_ID` = '207323746' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T16:01:57.913' ,`MLSNumber` = '2432009' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.403371' ,`Longitude` = '-95.503927' ,`PhotoCount` = '20' ,`PostalCode` = '77318' ,`RoomCount` = '10' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Carina Gaze' ,`StreetNumber` = '546' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3398' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Two-story rotunda entry. Family room with a wall of windows and a wood mantel fireplace. Home office with French doors and formal dining room. The kitchen features an island with built-in seating space, a double wall oven, a 5-burner gas cooktop, a walk-in pantry, and Butler\'s pantry. The kitchen also opens to the morning area and family room. Secluded primary bedroom. The primary bath includes a corner garden tub, a separate glass-enclosed shower, dual vanities, two walk-in closets, and a linen closet. Game room, media room, secondary bedrooms, and Hollywood bath complete the second floor. Abundant closet space. Extended covered backyard patio. Mudroom just off the three-car garage.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'PERRY HOMES' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7958' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347690' WHERE `Matrix_Unique_ID` = '207859852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T16:58:43.670' ,`MLSNumber` = '44480406' ,`ListAgentFullName` = 'Afzaal Rizvi' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.626602' ,`Longitude` = '-95.676483' ,`PhotoCount` = '49' ,`PostalCode` = '77498' ,`RoomCount` = '8' ,`ListPrice` = '514900.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Creek' ,`StreetNumber` = '13111' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully renovated beautiful home in Orchard Lake. Brand new appliances Oven, Microwave, Dishwasher, Garbage disposable, updated plumbing, new wooden floor, new sprinkler system, new fresh paint inside and outside of the house, new garage door opener and updated landscaping. Spacious floor plan in the gated community of Orchard Lake Estates. Upon entering the home, the high ceilings and gorgeous dark wood floors welcome you into a formal dining room and formal living room that can also be used as a home office/study. The tall ceilings continue into the family room featuring a fireplace and a wall of windows with blinds. This is truly a home for the family with the open concept kitchen with plenty of cabinets, granite countertops with center island and stainless steel appliances. The primary bedroom and bathroom is located on the first floor and features an oversized walk-in closet. 2 full bathrooms and a game room on 2nd floor. This home is a must see in this beautiful community.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ORCHARD LAKE ESTATES SEC 1, BLOCK 7, LOT 40, 50.000000% UDI' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OYSTER CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Orchard Lake Estates' ,`TaxAmount` = '4280' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347691' WHERE `Matrix_Unique_ID` = '208024971' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T15:42:01.413' ,`MLSNumber` = '43971878' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.132607' ,`Longitude` = '-95.645384' ,`PhotoCount` = '28' ,`PostalCode` = '77486' ,`RoomCount` = '3' ,`ListPrice` = '187000.00' ,`Status` = 'Active' ,`StreetName` = 'Loggins' ,`StreetNumber` = '810' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous neighborhood! Terrific 3 bedroom and 2 bath home with a double car garage. Enjoy preparing meals in this impressive kitchen equipped with white cabinets and generous counter space. Discover a bright interior with neutral tile floors and plush carpet in all the right places. The main bedroom boasts a private ensuite with a single sink and a closet. Other bedrooms offer plush carpet, ceiling fans, and sizable closets. Lush green landscape surrounds this beautiful house. Don\'t wait! Make this beautiful home yours today. This home has been virtually staged to illustrate its potential' ,`Acres` = '0.2152' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROLLING MEADOW (A0040 J H BELL DIV 1)(WEST COLUMBIA) BLK 1 L' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rolling Meadow' ,`TaxAmount` = '3596' ,`TaxRate` = '2.4263' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675347691' WHERE `Matrix_Unique_ID` = '208397814' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T16:25:37.753' ,`MLSNumber` = '22300247' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.021789' ,`Longitude` = '-95.327917' ,`PhotoCount` = '42' ,`PostalCode` = '77338' ,`RoomCount` = '15' ,`ListPrice` = '364990.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Woods Mist' ,`StreetNumber` = '6843' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful Postwood Homes property in Cypresswood Point is what you’re looking for. Situated on a cul-de-sac lot, this 3-sided brick home boasts a premium elevation, no back neighbors, tile flooring, wrought iron spindles, study with French doors, open great room, sprinkler system, and a covered patio. Impress your guests in the kitchen, complete with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and undercabinet lighting. The relaxing primary suite features dual vanities, a 42” tub, and a separate shower. Community comforts include a recreation area with a park, pool, and playground. Commuters will love the easy access to U.S. 59 and Hardy Toll Road. Residents enjoy close proximity to the popular Deerbrook Mall, Bush Intercontinental Airport, and Cypresswood Golf Club. Schools are a part of Aldine ISD. Don’t miss out on this stunning home – call today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Postwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Point' ,`TaxAmount` = '' ,`TaxRate` = '2.93' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347692' WHERE `Matrix_Unique_ID` = '208546959' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T16:13:57.023' ,`MLSNumber` = '82071675' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.897893' ,`Longitude` = '-95.739605' ,`PhotoCount` = '9' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '331490.00' ,`Status` = 'Active' ,`StreetName` = 'Costalinda' ,`StreetNumber` = '21422' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Escape the city to this gorgeous Lake Ridge Builders home in Marvida! Nestled on a spacious lot, this 3-sided brick home boasts a stone elevation, tile flooring, faux wood blinds, full gutters, a sprinkler system, and a covered patio. Try a new recipe in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Spend relaxing evenings in the primary suite, featuring dual vanities, a 42” tub, and a separate shower. Community amenities include clubhouses, pools, playgrounds, state-of-the-art workout facilities, tennis courts, basketball courts, and a dog park. Situated near the Grand Parkway and Highway 290, commuters enjoy the ease of access to the Energy Corridor, Houston Premium Outlets, and Downtown Houston. Schools are a part of the top-rated Cypress-Fairbanks ISD. Don’t miss out – call now for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675347693' WHERE `Matrix_Unique_ID` = '208689652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T15:56:56.720' ,`MLSNumber` = '69465802' ,`ListAgentFullName` = 'Cody Osgood' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.963626' ,`Longitude` = '-95.291957' ,`PhotoCount` = '46' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '720000.00' ,`Status` = 'Active' ,`StreetName` = 'Dolphin' ,`StreetNumber` = '98' ,`StreetSuffix` = 'Lane' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 4/2.5 home in Bridge Harbor. Great rental potential. 4 bedrooms, could even make it 5 bedrooms. Come see it today! All room measurements are approx. FURNITURE INCLUDED!' ,`Acres` = '0.0964' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BRIDGE HARBOR (A0051 DIV 8 (B C I C)) (FREEPORT) LOT 98' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '4199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Bridge Harbor' ,`TaxAmount` = '8704' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347694' WHERE `Matrix_Unique_ID` = '208931233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T15:00:23.177' ,`MLSNumber` = '33436785' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.059586' ,`Longitude` = '-95.533393' ,`PhotoCount` = '27' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinefern' ,`StreetNumber` = '6903' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2-story brick home with well manicured lawn, pool, spa and mature landscaping. Located in Windrose West neighborhood on a cul-de-sac, this home features 4 bedrooms, 3.5 baths and 3 car garage. Fresh interior paint and new carpet thru out. 2 story entry. Front office with french doors. Formal dining room. Living room with fireplace. The gourmet kitchen boasts a center island with breakfast bar, granite counters, tile backsplash, white cabinets and Stainless steel microwave, oven and gas range. Downstairs master bedroom with ensuite bath. Secondary bedrooms and game room upstairs. Enjoy entertaining in the backyard with pool, spa and covered patio. Community features pool, playground, walking trails and lake. Located on corner of 2920 and 99 for easy access to highway. Must See!' ,`Acres` = '0.3459' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 WINDROSE WEST SEC 14' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '15068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '877' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENIGNUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Windrose West' ,`TaxAmount` = '11077' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347694' WHERE `Matrix_Unique_ID` = '209844810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T15:46:23.983' ,`MLSNumber` = '26482724' ,`ListAgentFullName` = 'Dorothy Watts' ,`ListOfficeName` = 'Martindale Real EstateInvestments' ,`SellingAgentFullName` = 'Lacy Troutman' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.779962' ,`Longitude` = '-94.425484' ,`PhotoCount` = '42' ,`PostalCode` = '75979' ,`RoomCount` = '10' ,`ListPrice` = '249000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Temple Street' ,`StreetNumber` = '517' ,`StreetSuffix` = '' ,`City` = 'Woodville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful property sits on the corner and has a very large backyard with a gorgeous oak tree. It is fenced and the backyard has plenty of room for playing or for your animals. This home has been remodeled and has a nice big den and also living room with built in shelves and cabinets. The kitchen has a large island for entertaining and the dining area is also spacious. Its an open concept home. The den is a very large room so it can be used for extra living or a gameroom whichever you choose. It has a 2 car covered carport but the driveway can hold extra cars. It has a large gate in the back in case you need to store your boat or atv or motorhome.' ,`Acres` = '0.742' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0657 J. Wheat Block 52, Tract B Acres .742' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '253 - Woodville' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'n/a' ,`TaxAmount` = '3330' ,`TaxRate` = '2.3293' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675347695' WHERE `Matrix_Unique_ID` = '209903009' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-01T15:31:53.047' ,`MLSNumber` = '23176434' ,`ListAgentFullName` = 'Elizabeth Vanderbrouk' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName`